After Fixing FAX Numbers, Cannot ReImport CSV File

[James Henderson]

I cannot reverse an Export from Outlook to CSV

Before I did the export, only the contact email address (e-mail address removed)
appeares in the E-mail field, and a name in the the "Display as:" field.

The word SMTP comes up if I double click the E-mail field for editing,
when a grayed-out "E-mail type:" shows it to be SMTP.

I exported my Outlook 2002 Contacts to a CSV file. In the column headed
"E-mail" Outlook 2002 puts three items:

1. E-mail address
2. Then the word "SMTP" (without quotes)
3. And then the "Display as:" field (usually the full name and the
address again)

These appear all in the one column, NOT IN three separate columns.
It seems that the "Address", SMTP, and "Display as:" become one field.

The column looks something like
E-mail
(e-mail address removed) SMTP Doug Peterson ([email protected])
[THIS IS A FAKE EMAIL ADDRESS]

When I re-imported the 856 contacts back into Outlook, only modifying
the Business FAX column to include an aphabetic character so that there
are not two entries for each contact, all the Email addresses are messed
up. E-mail entry nows contains all three of the fields above, NOT just the
E-mail field. KB Article 305361 descibes how to do this.

What did I do wrong? How should the E-mail field in Outlook 2002 look in
the CSV file? How can I recover my E-mail addresses? Help!!!!!

 

[Russ Valentine [MVP-Outlook]]

This is not a fax issue.
Just curious. Why would you ever export to a CSV file simply to reimport
into Outlook? Two unnecessary changes in file format is an invitation for
trouble.
There is also no need to import and export at all. Import and Export is a
poor choice for transferring data from one Outlook installation to another.
Leave the PST file intact and simply open it in the other installation to
transfer data.