Outlook Contacts Importing HELP...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johnathon Aaron Steel - 15 Jun 2005 22:22 GMT

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 "email@email.com," 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

Reply to this Message

Sue Mosher [MVP-Outlook] - 15 Jun 2005 22:52 GMT

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

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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
[quoted text clipped - 10 lines]
>
> JAS

Reply to this Message

Johnathon Aaron Steel - 15 Jun 2005 23:20 GMT

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

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 15 Jun 2005 23:53 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> my 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.

Reply to this Message

Johnathon Aaron Steel - 16 Jun 2005 02:20 GMT

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

Thanx

>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.

Reply to this Message

Sue Mosher [MVP-Outlook] - 16 Jun 2005 02:56 GMT

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

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> thats where I am stumped I never use Excel all that much :(
>
> Thanx
>
>>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.

Reply to this Message

Johnathon Aaron Steel - 16 Jun 2005 03:06 GMT

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

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 16 Jun 2005 03:12 GMT

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

And you need to save the file.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> LOL Ok yes I could heheh
>
[quoted text clipped - 9 lines]
>
>>I think you can probably find the Insert menu and the other commands.

Reply to this Message

Johnathon Aaron Steel - 16 Jun 2005 03:35 GMT

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

Thanx

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 16 Jun 2005 12:39 GMT

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/

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Column "A" is the only on with data. Cell 1 - 800 has email addys.
>
[quoted text clipped - 3 lines]
>>
>>And you need to save the file.

Reply to this Message

Johnathon Aaron Steel - 16 Jun 2005 15:24 GMT

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

>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/

Reply to this Message

Sue Mosher [MVP-Outlook] - 16 Jun 2005 20:53 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> We are a Charity and we send out a newsletter bi-weekly so thats why I
> just have the email addresses :)
[quoted text clipped - 6 lines]
>>
>>But I have to ask: Why would you want to import just addresses into Outlook without names/

Reply to this Message