Import email address in an Excel to a DL

J

Joseph Liu

I have an Excel file containing 100+ email addresses which belong to one DL.
How can I import them to Outlook 2003?
 
M

Milly Staples [MVP - Outlook]

Import them into a contact folder that you create. Then, create a new DL
and select members from that contacts folder. Select the first one and use
Ctrl+A to select all, add them to the DL.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, Joseph Liu asked:

| I have an Excel file containing 100+ email addresses which belong to
| one DL. How can I import them to Outlook 2003?
 
J

Joseph Liu

Hi Milly,

I tried your suggestion but I can't save the list because I was told that
the list contains too many members. After counting, the list I created
contains only 147 members. Please advise how to solve.

Joseph
 
G

Gordon

Joseph Liu said:
Hi Milly,

I tried your suggestion but I can't save the list because I was told that
the list contains too many members. After counting, the list I created
contains only 147 members. Please advise how to solve.

Why bother importing at all? Use Mailmerge and select the Excel sheet as the
address database....
 
N

Noel

I imported my list from a .csv file. Now my number has went from 1292 to 2950
items imported. Why is it adding more? I am using Excel and Outlook 2003

Thanks
 
Top