Import fields from Excel go into different Outlook contacts

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.
 
K

Karl Timmermans

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
Problem importing data from Excel into Outlook 2007 Contacts 3
import excel contact list into outlook 2
importing info from Excel into outlook contacts 2
excel 2007 how to name ranges so u can import into outlook 07 2
automatically add sender to contacts from a message, and associate withcategory 1
importing multiple excel fields into outlook contacts 1
Importing contact data from Excel 4

Top