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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Contacts From Excel to Outlook Not Working 3
import excel contact list into outlook 2
Problem importing data from Excel into Outlook 2007 Contacts 3
importing info from Excel into outlook contacts 2
Creating Distribution Lists from Contacts 1
Importing contact data from Excel 4
Contact not importing names of csv lists 2
Some data from Contacts not exported into Excel (OL 2010) 2

Back
Top