import form excel to outlook

P

peartree

Hello everybody,

I have got a problem with importing a lot of e-mail
adresses from excel to outlook. First thing I did was
creating a template by making an export of my contacts
from outlook to excel. Then I emptied the template except
for the first row and copied the e-mail adresses into the
template and saved the file. The importing of the excel
file in outlook works but it only imports a certain range
(as much e-mail adresses as I first exported from my
contacts to make the template). I think I have to change
the range in Excel but I have no idea how this should be
done. Can anybody help me please.

Greetings,

Mark Peereboom
 
S

Sue Mosher [MVP-Outlook]

Use the Insert | Name | Define command in Excel to define a named range that
covers all the data you want to import. Specify that range when Outlook's
Import and Export wizard prompts you.
 

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

Excel list with contacts 1
How do I copy my adresslist to a different computer 1
import adress book from outlook express to outlook 1
Ooutook with Exchange-Server: Export of contacts creates X.400-Addresses 0
Restoring address book from backup, Outlook Express 1
Import Contacts From Excel to Outlook Not Working 3
Outlook - Palm and Chapura 2
Changeing of e-mail adresses 1

Top