how do I import contacts in excel with email addresses included?

  • Thread starter Thread starter riemster1
  • Start date Start date
R

riemster1

need help. I imported my contacts from excel to Outlook contacts but the
email addresses from my contacts did not appear in the Outlook Contacts.
 
check the named range in excel extends to the email address column - see Ben
M Schorr's answer to my similar question below - "Problem importing contacts
from excel 2003 to outlook 2007"
 
There are 3 different things off the top that need to be checked

#1 - Your Excel named range as noted in the response from Adrian but in this
particular case, doubt the "named range" is the problem unless your email
addresses are in the last column not covered by the named range

#2 - Did you manually map your fields or let Outlook <AutoMap> and expect
the field to be mapped correctly (depending on auto-map is a leading cause
of things not getting imported)

#3 - If you manually mapped the fields - what field exactly did you map the
Email Address to? What other email fields did you map (i.e. Email Address
Type). If your email addresses are simple SMTP addresses - should be mapped
to <Email Address> (or <Email 2 Address> etc) and should let Outlook fill in
the Address Type field.

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
 
Back
Top