Outlook Contacts Importing HELP...

[Johnathon Aaron Steel]

Here is my dilemma. I have Outlook 2003 and I have created a
distribution list called "Mass". Now I have no email address's in
there yet but I want to import 800 email address's into this folder
from an excel sheet.

I have 800 cells and every cell has an "(e-mail address removed)," just like
that without the quotes but WITH the ",".

Now question is can I import these 800 addresses directly into a
distribution list or is there a way.

Thanx

JAS

 

[Sue Mosher [MVP-Outlook]]

No, there is no way to import into a DL. You can import into a folder, however, and then use that folder as the so9urce for a mail merge (which is better than a DL).

 

[Johnathon Aaron Steel]

Ok no wmy next question is when I get "The MS Excel file "example" has
no named ranges. Use MS Excel to name the range of data you want to
import.

--Newbie

 

[Sue Mosher [MVP-Outlook]]

Do what it says: In Excel, use the Insert | Name | Create command to create a named range covering all the data you want to import.

 

[Johnathon Aaron Steel]

thats where I am stumped I never use Excel all that much

Thanx

 

[Sue Mosher [MVP-Outlook]]

I think you can probably find the Insert menu and the other commands.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Johnathon Aaron Steel]

LOL Ok yes I could heheh

I highlight column "A" and do the creat thing, I chose "Top Row" (hope
thats ok), Click create name and bang it goes away.

Then when I try and import it gives me the same error as I stated in
the first msg

Arggg

Thanx

 

[Sue Mosher [MVP-Outlook]]

You need to highlight *all* the data you want to import, not just Column A.

And you need to save the file.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Johnathon Aaron Steel]

Column "A" is the only on with data. Cell 1 - 800 has email addys.

Thanx

 

[Sue Mosher [MVP-Outlook]]

That's probably not going to work very well. Outlook needs names for contacts, not just email addresses. You could copy/paste the addresses to a second column and map that column to the name field.

But I have to ask: Why would you want to import just addresses into Outlook without names/

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Johnathon Aaron Steel]

Darn, Oh well least I tired and you helped out TONS and I thank you.

We are a Charity and we send out a newsletter bi-weekly so thats why I
just have the email addresses

Thanx again

JAS

 

[Sue Mosher [MVP-Outlook]]

You don't need to import those messages. Just start a mail merge in Word, select the Excel worksheet and range as the data source and set the output to email.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers