Import email address in an Excel to a DL

[Joseph Liu]

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

 

[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?

 

[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

 

[Gordon]

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

 

[Diane Poremsky [MVP]]

there is current a limit of 99 names in a dl - you'll need to make 2 - you
can 'nest' a dl inside a dl to keep them together.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[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