importing contact data from Excel

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,
 
S

Sue Mosher [MVP]

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.
 

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

Top