I want to export the information from a mailbox in Outlook to an Excel
file. I can do that, it gives me a spreadsheet with my choice of:

- Subject
- Body
- To (Name, Address, Type)
- From (Name, Address, Type)
- CC (Name, Address, Type)
- BCC (Name, Address, Type)
- Billing Information
- Categories
- Importance
- Mileage
- Sensitivity

...isn't there something conspicuous missing from this list? Namely,
date/time? What day the email was received is exactly what I want to
be processing in Excel. This mailbox receives automated emails and I
want to trend activity over time. Can someone suggest a way to get
date information to Excel?

see http://www.slipstick.com/emo/2007/up071004.htm#5 for the solution.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Todd Walton" wrote in message
ups.com...
I want to export the information from a mailbox in Outlook to an Excel
file. I can do that, it gives me a spreadsheet with my choice of:

- Subject
- Body
- To (Name, Address, Type)
- From (Name, Address, Type)
- CC (Name, Address, Type)
- BCC (Name, Address, Type)
- Billing Information
- Categories
- Importance
- Mileage
- Sensitivity

..isn't there something conspicuous missing from this list? Namely,
date/time? What day the email was received is exactly what I want to
be processing in Excel. This mailbox receives automated emails and I
want to trend activity over time. Can someone suggest a way to get
date information to Excel?