importing contact data from Excel

  • Thread starter Thread starter BobSYS
  • Start date Start date
B

BobSYS

When I try to import e-mail addresses from a large Excel
file, it tells me to assign a range to the cells. When I
do that, all the contacts come in as separate contacts.
One for first name, last name, company name, etc. Rather
than all data in a single contact.

I have named the columns in Excel
as "company" "firstname" "lastname" "email". That is all
the information I want in each contact. I have about 600
names that I want to put into the Contacts folder.

Can anyone tell me how to name the Excel list?
Thanks,
 
Outlook doesn't care what you name the range that includes all the data. It
just needs a named range. Include the column heading cells in the range for
best results.
 
You must log in or register to reply here.

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

Problem importing data from Excel into Outlook 2007 Contacts 3
Importing Excel files to Outlook contact 5
Importing contact data from Excel 4
Some data from Contacts not exported into Excel (OL 2010) 2
Import Contacts From Excel to Outlook Not Working 3
contacts : export to excel and import again - "file as' is changin 1
excel 2007 how to name ranges so u can import into outlook 07 2
Importing Contacts 2

Back
Top