Do you have to create a distribution list one entry at a time?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bj - 02 Apr 2006 00:19 GMT

I have a major list of customers that I want to put into the distribution
list. I managed to glean the email address from the list, however I find
that I have to enter each address one at a time. Is there no way to import
the addresses (not in personal address book), to the distribution list. Must
you install each one (hundreds), one at a time?

Reply to this Message

William Lefkovics [MVP] - 02 Apr 2006 00:29 GMT

The addresses have to be somewhere importable - Excel spreadsheet or
another messaging application for example. Then you can import them into
your contacts. From there you can select them through the interface and not
have to type them manually. I don't think you can import them directly into
the distribution list in Outlook.

So.. in what format is this customer list?

>I have a major list of customers that I want to put into the distribution
> list. I managed to glean the email address from the list, however I find
[quoted text clipped - 3 lines]
> Must
> you install each one (hundreds), one at a time?

Reply to this Message

bj - 02 Apr 2006 02:18 GMT

> The addresses have to be somewhere importable - Excel spreadsheet or
> another messaging application for example. Then you can import them into
[quoted text clipped - 11 lines]
> > Must
> > you install each one (hundreds), one at a time?

Thank you for the reply but it does not help me. The information is on a
cd, and is in excel, which is how I gleaned the email addresses, and I did
create a folder for them, however I still have the problem of copy/paste all
of them for hours, or not. I do not have to type them into the list, I am
sorry I did not make that clear, but to copy and paste takes forever. I
wanted to copy them all to one distribution list, such as (wholesale) or
(Retail), and cannot.

Reply to this Message

William Lefkovics [MVP] - 02 Apr 2006 03:48 GMT

If they are in a properly formatted excel file (like a comma separated value
file .csv) importing them into Outlook may be more useful than copy/paste.

In Outlook you can import them into contacts:
Copy the excel file to disk.
File-->Import and Export-->Import from another program or file-->Comma
Separated Values (Windows)
Select the Contacts folder.

From there it would be much easier to create the distribution lists.

If the Excel file is not a .csv you have to assign a name to the range of
data you want to use from Excel. It is outlined in the Help in Excel.

>> The addresses have to be somewhere importable - Excel spreadsheet or
>> another messaging application for example. Then you can import them into
[quoted text clipped - 24 lines]
> wanted to copy them all to one distribution list, such as (wholesale) or
> (Retail), and cannot.

Reply to this Message

bj - 02 Apr 2006 18:08 GMT

> If they are in a properly formatted excel file (like a comma separated value
> file .csv) importing them into Outlook may be more useful than copy/paste.
[quoted text clipped - 9 lines]
> If the Excel file is not a .csv you have to assign a name to the range of
> data you want to use from Excel. It is outlined in the Help in Excel.

I do appreciate your assistance, and perhaps I am being unclear in my
explanation, therefore allow me to digress. I do not have a problem getting
the list from cd to outlook, as the import works well to set the list of
names in a folder. If I do this, I still am left with the chore of getting
the email addresses to the distribution list and regardless the list has no
import and requires that you enter each email address one at a time. It is
still copy and paste even from an outlook folder or from the excel listing,
or it is type it in one at a time. I do not understand why you cannot import
or enter more than one email address at a time?

Reply to this Message

Judy Gleeson - 03 Apr 2006 06:20 GMT

If you just use Contacts and categorise them, you can use more functions
that with DLs. For example, mailmerge (email or documents) to clients is
often a useful function. So why use DLs? You'll find many negative
comments from MVPs here about the problems with DLs.

Judy Gleeson
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

>> If they are in a properly formatted excel file (like a comma separated
>> value
[quoted text clipped - 27 lines]
> import
> or enter more than one email address at a time?

Reply to this Message