Import received e-mails from Outlook to MSSQL database

Posted by _simon_ on Stack Overflow See other posts from Stack Overflow or by _simon_
Published on 2010-05-11T07:31:58Z Indexed on 2010/05/11 7:34 UTC
Read the original article Hit count: 330

How can I automatically import some data from received e-mail from Outlook to MSSQL database?

So, when I receive an e-mail (from a preset sender), Outlook should be able to run an external application with the subject and body as parameter. This application will then parse the body of the e-mail and send it to database.

Is it possible to set this in 'Rules and alerts' in Outlook (I don't think so)? Or is it possible to do it with macros (an example would be nice). Or else...?

I am using Microsoft Outlook 2007 (no Exchange Server), let's say, that incoming mail is from @gmail domain, the externam application would probably be a C# console application, database is SQL SERVER 2005.

© Stack Overflow or respective owner

Related posts about outlook-2007

Related posts about automation