How to Export Multiple e-mails of the same format into Excel

[Guest]

I have many e-mails all of the same format, as far as where information is
located. I have a need to export these e-mail contents into columns in Excel
How can I do this?

 

[Sue Mosher [MVP-Outlook]]

You mean the body of the mail messages contain data in rows and columns? You could open each message and copy and paste to Excel. Or, analyze the message body and write a macro to parse it and push the data into a spreadsheet.

 

[Guest]

This worked for me on up to 500 emails at a time:
-Have "auto preview" on
-Select all desired messages
-Print to PDF...not to a printer
-Open PDF and save as text (accessible) txt file
-Smaller files can open in Excel (max. 65,000 lines)
-Large files open via Access as a space delimited file (I've gone to 2M+
records)
-Data can be viewed, sorted. Cut & paste desired data into Excel