Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2013, 12:11 PM
tpieples tpieples is offline How do you get the DATE and TIME fields to be included in an export to Excel? Windows 7 64bit How do you get the DATE and TIME fields to be included in an export to Excel? Office 2010 64bit
Novice
How do you get the DATE and TIME fields to be included in an export to Excel?
 
Join Date: Feb 2013
Posts: 1
tpieples is on a distinguished road
Default 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!
Reply With Quote
Reply

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
How do you get the DATE and TIME fields to be included in an export to Excel? Date--Time shortcut problem markg2 Excel 3 10-27-2012 03:49 AM
How do you get the DATE and TIME fields to be included in an export to Excel? 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
How do you get the DATE and TIME fields to be included in an export to Excel? Sent emails all have same date/time?? Confused Outlook 3 01-07-2011 07:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft