Contact Import omits Email Address

[Mark]

I have successfully exported a list of contacts from Outlook 2007 into Excel
2003, when importing them back into Outlook 2007 on a different machine the
email address details are not being populated.

Can anyone suggest a resolution?

 

[Russ Valentine [MVP-Outlook]]

You would never transfer Outlook data in this fashion. There is no need to
export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.

 

[Mark]

Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving companies..
I don't have access to the original PC and now have the contacts in an Excel
file. It imported every other field without an issue but is omitting the
email address fields for some reason.

Any ideas to save me inputting them all by hand?

You would never transfer Outlook data in this fashion. There is no need to
export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]

I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?

 

[Russ Valentine [MVP-Outlook]]

Yes. PST is Outlook's native format for a data file.
You should still be able to import from Excel. List the steps you used. Make
sure you use a named range in Excel and have mapped your fields correctly.
The email addresses should populate correctly. The only thing that often
goes wrong is that the addresses will not resolve, so will not appear in the
address book view until you open and save each Contact Record. A third party
utility may be able to help you with Outlook's shortcomings:
http://www.contactgenie.com/

--
Russ Valentine
[MVP-Outlook]

Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving
companies.. I don't have access to the original PC and now have the
contacts in an Excel file. It imported every other field without an issue
but is omitting the email address fields for some reason.

Any ideas to save me inputting them all by hand?

You would never transfer Outlook data in this fashion. There is no need
to export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]

I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?

 

[Karl Timmermans]

When mapping the email address - what email fields are you using for the map
on the Outlook side of things?

More to the point, the email address field in your Excel worksheet which
should contain only (e-mail address removed) should be specifically mapped to one of
the following on the Outlook side "Email Address", "Email 2 Address", or
"Email 3 Address". If you map to either Email, Email 1, or Email 3 - you may
end up with an invalid value in the "Email Type" field causing the problem
you describe. Under normal circumstances, there is no need to map the Email
Type field when importing.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving
companies.. I don't have access to the original PC and now have the
contacts in an Excel file. It imported every other field without an issue
but is omitting the email address fields for some reason.

Any ideas to save me inputting them all by hand?

You would never transfer Outlook data in this fashion. There is no need
to export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]

I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?

 

[Sarah0824]

I just wanted to thank you for this post, Karl. It solved the problem I was
having with importing from Excel. You saved me a TON of time and allowed me
to keep the hair on my head!!

When mapping the email address - what email fields are you using for the map
on the Outlook side of things?

More to the point, the email address field in your Excel worksheet which
should contain only (e-mail address removed) should be specifically mapped to one of
the following on the Outlook side "Email Address", "Email 2 Address", or
"Email 3 Address". If you map to either Email, Email 1, or Email 3 - you may
end up with an invalid value in the "Email Type" field causing the problem
you describe. Under normal circumstances, there is no need to map the Email
Type field when importing.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving
companies.. I don't have access to the original PC and now have the
contacts in an Excel file. It imported every other field without an issue
but is omitting the email address fields for some reason.

Any ideas to save me inputting them all by hand?

You would never transfer Outlook data in this fashion. There is no need
to export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]
I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?