Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

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

2011-08-13 17:47:00
MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT
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.Outlook2Excelhttp://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 ...