Import Data from an MS OutLook Email

[cricketer1]

I have a scenario where a single coulmn of data is coming to me in an email on MS OutLook. How can I import this data into a table directly from the email, can this be automated too.

Thanks

 

[jhall01]

Is it in the body of the email or as an attachment?

You could do a little VBA for Outlook to parse the body of the email and insert into the database.

There are many ways to do this. You could parse the body, create a connection using ADO and then insert the parsed text.

or

Parse the text, use the FSO library and save the parsed text as a text file and build a DTS package to import the data.

It just depends on how you want to do it!

Jon

 

[cricketer1]

Thanks for your response...

yes the data is embedded in the email.

I was actually looking for a way to make a connection to MS outlook from SQL Server, both of these, outlook and sql server are on different machines.

or do you recommend somehow parsing out the data in the email to a text file and then taking it from there...I am looking to put all of this in a DTs package.