Import email address in an Excel to a DL

  • Thread starter Thread starter Joseph Liu
  • Start date Start date
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?
 
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?
 
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
 
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.
Click to expand...

Why bother importing at all? Use Mailmerge and select the Excel sheet as the
address database....
 
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.
 
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
 
Back
Top