Exporting outlook email headers

March 27, 2006 7:35 AM

So I'm doing my expenses, and I want to see every night I sent an email after 8:00 or so, because that implies I took a cab home that night. (I can bill them without receipts, but I want to be honest and I'm doing this for a couple months.) Is there a way to export email headers from Outlook to excel or a csv file, so I can sort them by time and count up my trips?
posted by mtstover to computers & internet (6 comments total)

You can export mailboxes in a variety of formats, but when I've done this I have not been able to export the time and date information.
posted by alms at 7:43 AM on March 27, 2006

Click on email in list. Click File -> Save As. Choose a name, and the .txt extension.

This will save the date and time.

A VBA macro can be used to get more details from the header.
posted by SuperSquirrel at 9:33 AM on March 27, 2006

Oops, sorry, I didn't read the whole post closely. :-/

You can save more than one email at time using the method I mentioned.

Once you have a text file of the emails in question, you can open it in Word, rearrange the data into tables and then sort by whatever criteria you choose, or copy and paste the table into Excel to make use of Excel's formula's.
posted by SuperSquirrel at 9:44 AM on March 27, 2006

GAH! formula's should be formulas
posted by SuperSquirrel at 9:46 AM on March 27, 2006

I have done this at work and I think you can just select all the email headers (without autopreview) and copy and paste these into Excel. This will take all the columns that you have displayed in the outlook list.
posted by pettins at 10:21 AM on March 27, 2006

Here's a quick VB example that exports stuff from outlook. You could probably quickly adjust this to simply examine the date (Probably something like If Message.Date = suchandsuch...) and give you a straight count.

I'd be more helpful with the specifics if I were around a Windows machine, but alas.
posted by odinsdream at 7:03 PM on March 27, 2006