Thanks for the suggestion. I've looked at the slipstick link. This gets me
partway there . . .
In the folder view in Outlook (i.e., the familar view that shows me a list
of messages ith From, Subject, Received, Size, etc.), the Received column
shows values like "Thu 5/28/2009 4:26 PM". But when I copy, then paste (or
paste special) into Excel, this value appears as "4:26 PM". I've checked the
type, and it is numeric (TYPE() = 1), and appears to be a date/time value.
But it looks like the value contains only the time part, because when I apply
a straight numeric format to it, I get 0.684722222222222. The date part,
which is what I most care about, is lost.
Any further suggestions?
Thanks.
Diane Poremsky said:
No. You can get them by copy and paste though. See
http://www.slipstick.com/Tutorials/copyto/excel.htm
--
Diane Poremsky [MVP - Outlook]
Outlook Tips by email:
mailto:
[email protected]
EMO - a weekly newsletter about Outlook and Exchange:
mailto:
[email protected]
You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
Eric_NY said:
I'm using Outlook 2003. I've exported a series of messages to an Excel
file.
The columns (fields) are Subject, Body, FromName, FromAddress, etc., as
expected.
But there are some missing fields, particularly Received Date/Time, Sent
Date/Time, etc. Is there a way to include these fields in the export?
Thanks.
