Outlook Contacts Importing HELP...

  • Thread starter Thread starter Johnathon Aaron Steel
  • Start date Start date
J

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