Outlook 2003 does not export all fields to any of the selected file formats

[Great Eyes]

Outlook 2003 does not export all fields, it is missing the date and time
field for messages.
If there is a way please let me know.

 

[Milly Staples [MVP - Outlook]]

For what purpose are you exporting your .pst items?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
without reading.

After searching google.groups.com and finding no answer, Great Eyes asked:

| Outlook 2003 does not export all fields, it is missing the date and
| time field for messages.
| If there is a way please let me know.

 

[Simon Kravis]

Outlook 2003 does not export all fields, it is missing the date and time
field for messages.
If there is a way please let me know.

A clunky way is to export to Excel then add a column for Received
Date, select all messages in the mail folder (ordered by date, copy to
clipboard and paste into Excel. The Received Date will then be present
as a column whoese rows match up with the exported data. However, the
date format as pasted (eg Fri 29/1/2004 1:00 PM) is not interpreted by
Excel as a date. To make it interpreted as a date, remove the 1st 4
characters with the Excel Mid() function and use the excel Value
function to convert to Excel date format ie Value(Mid(A1,4,30)). Once
the column is converted to date format it can be copied into the
Received Date column of the exported data, or pasted into a new Access
field if the mail data has been exported there.