Cannot view dates of emails(no date field), in my CSV file exported from MS Outlook

Posted by barlop on Super User See other posts from Super User or by barlop
Published on 2013-05-15T19:15:02Z Indexed on 2014/06/01 9:30 UTC
Read the original article Hit count: 245

Filed under:

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.

© Super User or respective owner

Related posts about microsoft-outlook