Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using Outlook 2010 - I have my emails showing in there.

and exported my emails, into a csv file. (file..options..advanced...export..export to a file..

I have opened that csv file in excel

Here is a list of the fields it shows. I see "Date" doesn't appear among them.

Subject Body    From: (Name)    From: (Address) From: (Type)    To: (Name)  To: (Address)   To: (Type)  CC: (Name)  CC: (Address)   CC: (Type)  BCC: (Name) BCC: (Address)  BCC: (Type) Billing Information Categories  Importance  Mileage Sensitivity

Any idea why "Date" isn't included, and how to include it?

Also, (and less importantly, and as a very secondary issue) is there a convenient way to read the csv file? reading an email with a long body, in excel, is not convenient, I need to select all of the body from the cell and copy/paste it into notepad.

share|improve this question

1 Answer 1

Date is not an exportable field in Outlook. It's odd (to me anyway), but it's been like that for a long time.

If you happen to also have Access installed, you can use it to import mail from Outlook, and then you could dump the table into Excel.

In Access check out the "External Data" tab and click "More" to look for "Outlook Folder".

As for viewing the CSV. Excel is a good way as it properly separates the fields (into cells), but otherwise a CSV is just plain text, so load it into Notepad or Wordpad (or another text editor like Notepad++).

share|improve this answer
    
thanks, i'll try that, i'm generating a pst file at the moment from outlook(started before you posted your answer), it's taking a long while and seems to be much bigger. like the csv was about 76MB and this is 1.5GB so far. I'll give ms access a try once the pst is done. The ultimate destination i'm going to then try, is to gmail. I had tried directly, yahoo mail to gmail via pop(an old yahoo account that supports pop), but gmail only took or copied a month's worth of email like 600 emails or so. Outlook managed to copy the lot from yahoo via pop. –  barlop May 15 '13 at 20:45
    
your sentence saying "Date is not an exportable field in Outlook" Is not really a true statement, it's only true of CSV. I have tried it with "pst" and read it in outlook, and it has the dates. –  barlop May 16 '13 at 6:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.