exporting data from a table in outlook emails to excel.

  • Thread starter Thread starter Rob Etherington
  • Start date Start date
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
 
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.
 
Back
Top