How do you get the DATE and TIME fields to show up when you export an Outlook data file to Excel?
I've tried numerous times to import an Outlook .pst data file that contains thousands of emails. They show up perfectly in Outlook and display all fields, including the dates & times they were sent & received.
But, when I export the data file to Excel (using the csv or Excel 2003 options in the Import feature) the spreadsheet that is generated does not include the DATE and TIME the emails were sent or received. The date & time are vital in my spreadsheet.
HOW CAN I GET THEM TO DISPLAY?
I'd even be willing to manually copy the dates & times from the Outlook display into a new column in the Excel 2010 spreadsheet, but the emails are not in the same order as the generated spreadsheet! Ugh!!!
Please help ASAP! Thank you!