asked on

Outlook to Excel

I have a folder in excel that has about 150 emails in it. I would like to export the information in that folder to excel. The final result would be a row for every information with columns like: Date Received, Subject, Body, etc.

Any way to make this possible?

etech0

In outlook 2010 click file, options, advanced, export. Click export to a file, and choose comma separated values windows. Then select the folder, click next, and choose a destination.

cansevin

ASKER

Is it the same for 2007?

etech0

I think - Click the office button and look for export, either in the menu, or in options.

Fayaz

Select the first message>>press and hold shift key>>click the last message - now you should get all the messages selected or click one of the message and press control+a togather (this will select all the messages) an now press control+c and then open excel and press control+v.

cansevin

ASKER

I worked but it didn't include the date and time that it was sent. Is there anyway of making that happen? Thanks!

etech0

According to which method?

ASKER CERTIFIED SOLUTION

mark_harris231

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mark_harris231

Fayaz's method will get you the header information: From/Subject/Received/Size/Categories, but not the Body of the email. You should be able to generate a list from both methods and then marry the date/time to the export through a VLOOKUP on the subject content