Outlook Email content deliminate to Excel columns

[jlugo]

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,

Jess

 

[jlugo]

I found this post but it's a bit outdated & doesn't execute smoothly in VBA.

http://www.techrepublic.com/blog/msoffice/quickly-export-outlook-e-mail-items-to-excel/744

Would anyone have cleaner code that will work in this fashion?

 

[jlugo]

File -> Import/Export -> Export to a file -> Excel

Works but I'm still missing the date/time when I do this.

Any suggestion on how to get date and time onto this file?