August 1, 2003 at 4:06 am
Could someone point me in the right direction to get emails sent to me into a SQL table. Sender, subject and body text.
Thanks
August 1, 2003 at 4:14 am
Hi Rob,
quote:
Could someone point me in the right direction to get emails sent to me into a SQL table. Sender, subject and body text.
several ways to do that!
I started with the Exchange Driver from M$. You could create linked tables to a specified folder on your Exchange Server. Maybe this driver is still available for download.
I then utilized MAPI controls in VB to store mails. Pretty simple and straightforward, with the only disadvantage that you can only reach the inbox and not other folder.
Next was to utilise Outlook Object library via VB. Works really fine. You could reach any folder you want.
Now I utilise CDO. Very similar to Outlook olb, but I think more elegant.
Do you want this directly converted from mail to table row, or do you want a small placed in between? And if the latter is VB ok for you?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
August 1, 2003 at 4:20 am
Thanks. VB is a bit over the top for what I want. If there is an Exchange driver then that would probably be OK. I'll have a look. I've heard of people using sp_process mail in script. Any thoughts?
August 4, 2003 at 6:36 pm
xp_processmail is used for received emails in the mail box which SQL Mail uses specifically. In this case, you will have to configure all the emails you want to be put in a table to be forwarded automatically to the SQL Mail box and then use xp_processmail.
August 6, 2003 at 7:55 am
This sounds like the baby I'm after. Anyone know where I can go to learn all about this?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply