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: 328

Filed under:

outlook-2007

|

automation

|

external-application

|

sql-server-2005

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

Outlook 2007 unable to connect to exchange server

as seen on Server Fault - Search for 'Server Fault'
I came into the office a week ago and outlook has refused to connect ever since, it just says "Disconnected" in the bottom right-hand corner. I've tried restarting it, rebooting Windows etc. I'm the only one if our office who is having this problem, so it's not a general problem with the server.… >>> More
Outlook 2007 unable to connect to exchange server

as seen on Super User - Search for 'Super User'
I came into the office a week ago and outlook has refused to connect ever since, it just says "Disconnected" in the bottom right-hand corner. I've tried restarting it, rebooting Windows etc. I'm the only one if our office who is having this problem, so it's not a general problem with the server.… >>> More
Outlook 2007 Backup to D:\Outlook Fails - Access Denied, Write-Protected or File In Use

as seen on Super User - Search for 'Super User'
I can successfully save the Outlook PST file to the default location on the C drive (C:\Documents and Settings\user\ ... \Outlook) but when I change the backup save to directory to Outlook on the D drive I get the error: Cannot copy Outlook: Access is denied. Make sure the disk is not full or write… >>> More
Outlook 2007 freezes my system when I start it says it is "synchonizing folders"

as seen on Super User - Search for 'Super User'
When I try to start Outlook 2007, my system freezes, and Outlook says it is "synchonizing folders". I don't use exchange, and haven't seen any answers online. I've tried turning off the exchange integration (right clicking my folders) Since doing the latter, there is no longer an icon in the system… >>> More
why is Outlook 2007 continuously losing Connection to Exchange Server

as seen on Server Fault - Search for 'Server Fault'
what could be the reason for Outlook 2007 continously losing and reestablishing the connection to exchange? I tried disabling all anti-viruses and firewalls but it did not help. I should mention that even though this seems to happen to all users, some users cannot even send emails because it happens… >>> More

Related posts about automation

Documenting applications - automation / semi-automation for screenshots?

as seen on Stack Overflow - Search for 'Stack Overflow'
For me one of the biggest bores of being a developer is writing user documentation. (I am referring to the stuff that gets exported into PDF files files that ship with the product, not comments in code here). The task off adding or updating new bits of text to the existing documentation is OK. However… >>> More
Why the cucumber features keeps running even though it fails?

as seen on Stack Overflow - Search for 'Stack Overflow'
Its a rails 2.3.5 app. I'm using the rspec and cucumber for testing. When I run autospec, it runs correctly with the warning (Not running features. To run features in autotest, set AUTOFEATURE=true.) as below: [~/rails_apps/automation (campaign)?] ? autospec (Not running features. To run features… >>> More
Automation testing tool for Regression testing of desktop application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am working on a desktop application which uses Infragistic grids. We need to automate the regression tests for same. QTP alone does not support this, we need to buy new plug in for same which my company is not very much interested in. Do we have any open source tool for automating regression… >>> More
automation of data format conversion to parent child format

as seen on Stack Overflow - Search for 'Stack Overflow'
This is an excel sheet which has only a single column filled for each row. (explanation : all CITY categories fall under V21 , all handset categories fall under CityJ and so on ) V21 CITYR CITYJ HandsetS HandsetHW HandsetHA … >>> More
Automation: how to automate transforming .doc to .docx?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a bunch of .doc files in a folder which I need to convert to .docx. To manually convert the .doc to .docx is pretty simple: Open .doc in Word 2007 Click on Save As... Save it as .docx However, doing this for hundreds of files definitely ain't fun. =p How would you automate this? >>> More