Question Locked

Exporting Emails to Excel With the Date Received Field In

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I want to export email items from Outlook 2003 to Excel sheet. The problem is that for the our work it's essential that the received date and time is kept and shown in the Excel, and its not an option so far in MS OFfice.

If anyone knows an application, additional software that can be used along in order to keep the received date while exporting please share.

Thanks alot.

4 replies

by ludramon

Did you findout how to export the "received" info to the excel file?

by simonwils

If you are a bit of a wiz at visual basic then it can be done with some clever coding.

If not the easier way of doing this however is to open/create a new database with Access and select

File/Get External Data/Import from the top menus

then change the file type to "outlook". This will open a window where you can select which mail folder you want to import

when the data has imported you simply right click on the new table created and choose to export to Excel.

hope this helps

by blajge

Thank you very much Simon. This solves the issue for now.
Best Wishes

This discussion is closed to new replies.