Import contacts from Excel

[angie]

I have numerous contact lists with various categories and wondered if i can
import them into an email distribution list so that i do not need to hand
type each email?
thanks

 

[Brian Tillman [MVP-Outlook]]

I have numerous contact lists with various categories and wondered if i can
import them into an email distribution list so that i do not need to hand
type each email?

You can't import into a DL. Instead import into your Contacts and assign
categories to the imported contacts. See this:
http://www.slipstick.com/contacts/dl.asp#olcontacts

If you MUST use a DL, you can create the DLs like this:
http://www.outlook-tips.net/archives/2004/20041105.htm

 

[angie]

I tried importing from excel but i get an error about "ranges" . should the
criteria be under a particular range name (ie. First name versus First,etc...)

thanks

 

[Gordon]

I tried importing from excel but i get an error about "ranges" . should
the
criteria be under a particular range name (ie. First name versus
First,etc...)

You need to assign a name to the data range. If you don't know how to do
this, save the Excel file as a csv and import that.

 

[angie]

thank you for your help!!

You need to assign a name to the data range. If you don't know how to do
this, save the Excel file as a csv and import that.

.

 

[Gordon]

thank you for your help!!

YW!