Aug122011

How can I export the content of Outlook emails into separate columns in Excel?

J asks:

I have an email folder with multiple emails that contain similar content. I would like a quick way to move all the data into Excel. Separating each contact by columns is the goal: sent, to, date, email body etc.

I know I can save each email into notepad and copy into Excel and transpose, but this is too time-consuming.

Anyone up for this challenge please share any ideas or 3rd party application recommendations.

Thanks,

J



Comments for this Question are closed.

If you are looking for help, please ask a new question here.

We will be happy to help you!

1 Answer -

0 votes

Anonymous

August 13, 2011

Do you  have Access installed as part of your Office suite? possibly You can use
“Get External Data” in Access to absorb email in from Outlook, and the date field
can be included. From Access you can dump the table into Excel.

Outlook2Excel
http://www.oraxcel.com/projects/outlook2excel/

must save the mails in a folder on the hard drive (not archive) from Excel go to Data / Get External Data, import the text file, and get the hard drive data …