[REPOST] No date fields appear when exporting/importing CSV file?

  • Thread starter Thread starter Eugene Fan
  • Start date Start date
E

Eugene Fan

Hello All,

I need to convert some legacy emails from another system
to a format that can be read by Outlook. The preferred
format is CSV text, which we plan to import into Outlook.

I noticed when playing with the export/import that the
following seem to be the standard fields that get exported
into an Outlook generated CSV
file:

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

Notice neither the message Sent date or Receive date
appears.
I cannot get either date to appear in any test .csv I
export. If I add such a date column to a test .csv file I
import, Outlook
simply ignores it, imports everything else, and the
Receive or
Send date fields in the destination folder end up
with "None".

I cannot find a way to export nor import either the email
sent date or receive date. We would like to capture this
information somehow. Can somebody please tell me what I
may be doing wrong or missing?

Many thanks in advance.
 
Eugene,

I don't believe this is possible for Inbox items. The following article
outlines the available fields for the different folders.

195576 OL2000: Internal Fields Used by Outlook Folders
http://support.microsoft.com/?id=195576

Do you have the ability to export out the data into a different format?
 
Hi Greg,

Our main problem is on import. The export is not important, it is only
used to create a test .csv file. But since dates don't appear in
exports, I presume it cannot be imported either.

Our data source comes from database tables, not from Outlook or any
email system.
So we can only get the data in text format, ie. csv or tab delimited,
but not as an Outlook folder or .PST file. We cannot get a direct
IMAP/POP3/Exchange connection to the data source either.

We can create the data as tables in a (Oracle) database, but I don't
know how that would help.

If there are other options not yet considered, please advise.

Thanks in advance.
--
Eugene

greg mansius said:
Eugene,

I don't believe this is possible for Inbox items. The following article
outlines the available fields for the different folders.

195576 OL2000: Internal Fields Used by Outlook Folders
http://support.microsoft.com/?id=195576

Do you have the ability to export out the data into a different format?

--
Greg Mansius [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

Eugene Fan said:
Hello All,

I need to convert some legacy emails from another system
to a format that can be read by Outlook. The preferred
format is CSV text, which we plan to import into Outlook.

I noticed when playing with the export/import that the
following seem to be the standard fields that get exported
into an Outlook generated CSV
file:

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

Notice neither the message Sent date or Receive date
appears.
I cannot get either date to appear in any test .csv I
export. If I add such a date column to a test .csv file I
import, Outlook
simply ignores it, imports everything else, and the
Receive or
Send date fields in the destination folder end up
with "None".

I cannot find a way to export nor import either the email
sent date or receive date. We would like to capture this
information somehow. Can somebody please tell me what I
may be doing wrong or missing?

Many thanks in advance.
Click to expand...
Click to expand...
 
Back
Top