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.
Best Answer
Date is not an exportable field in Outlook (for CSV files). 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++).