Missing fields when exporting messages to Excel worksheet

  • Thread starter Thread starter Eric_NY
  • Start date Start date
E

Eric_NY

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.
 
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.
Click to expand...
Click to expand...
 
Back
Top