Import fields from Excel go into different Outlook contacts

  • Thread starter Thread starter Bob in Norman
  • Start date Start date
B

Bob in Norman

I have defined Names in Excel (Name, Title, Number, Email). When I import
into Outlook, it puts each item into a different Contact. It puts them into
the correct category (Name, Title, Number, Email) but rather than putting the
4 items into one contact, it creates 4 different contacts.
 
Clear all of your "named ranges" in your Excel worksheet and create only one
that encompasses both the header row (first row with column names) and all
rows that you want to import - no more - no less.

Alternative to dealing with named ranges is save your Excel worksheet as a
CSV file and import that into Outlook instead.

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