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