exporting data from a table in outlook emails to excel.

R

Rob Etherington

i currently have system set up so that i recieve a lot of automated
emails from a website, all containin a the same table which has been
filled out by many different people.

is there a way that i can get all the answers from that table into an
excel spreadsheet, and have it automated so that every time i recieve
another email into that folder it automatically opens it and then
updates the excel spreadsheet with the new information as well?

i would apprieciate it if anyone could help as this would save me a
lot of time everyday.

kind regards

rob etherington
 
E

Eric Legault [MVP - Outlook]

So this is an HTML formatted table in an HTML formatted e-mail?

You would need to parse the HTMLBody property of the e-mail message and
obtain the HTML between the <table> tag. Then you can paste this inside an
Excel spreadsheet and it will be converted automatically.
 
Top