|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you get the DATE and TIME fields to be included in an export to Excel?
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! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time & Date Formulas in Graphs | Ady_E | Excel | 5 | 11-15-2012 05:29 AM |
Date--Time shortcut problem | markg2 | Excel | 3 | 10-27-2012 03:49 AM |
Remove time portion in date | angie.chang | Excel | 4 | 06-13-2012 09:45 AM |
Date Fields | ubns | Word | 8 | 05-15-2012 11:20 PM |
Sent emails all have same date/time?? | Confused | Outlook | 3 | 01-07-2011 07:52 AM |