J
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!!!!!
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 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!!!!!