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?

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?

"bj" wrote in message
...
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?

"William Lefkovics [MVP]" wrote:

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?

"bj" wrote in message
...
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?

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.

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.


"bj" wrote in message
...


"William Lefkovics [MVP]" wrote:

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?

"bj" wrote in message
...
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?

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.

"William Lefkovics [MVP]" wrote:

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.


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?

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


"bj" wrote in message
...


"William Lefkovics [MVP]" wrote:

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.


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?