Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thiruna
Starting Member
41 Posts |
 Posted - 2002-07-25 : 08:06:59
|
| Hello Guys,Just a quick clarification... Is there a way to captures data from the email and store in SQL database....I have a table by name lessons learnt which has got Lesson_title, Lesson_description, lesson_learnt etc as the fields...Now i want to design some forms (in both lotus and outlook) for the users to feed in the lessons and send it to SQL database thru email directly from their email software.As soon as my SQL server receives the email, it has to split up the datas and store in the appropriate fields...I have searched for help in internet but couldnt able to find any useful information...Can anyone help me out to make this successful....? |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-07-25 : 08:42:33
|
| I have never tried it, but I know Outlook supports Macros. If you were to create a Macro that fired on the Mail_Received event (or something like that), then you could search say the subject line and if it contained Lessons Learned, then store the email body into a database using VBA.A quick look on Yahoo returned the following site that gives some indication of the types of events Outlook supports.[url]http://www.zdnet.com/products/stories/reviews/0,4161,2214403,00.html[/url]Let me know if you try this and it works.JeremyEdited by - joldham on 07/25/2002 08:50:12 |
 |
|
|
|
|
|
Capturing datas from email and store in database