A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Import email address in an Excel to a DL



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 17th 08, 06:57 AM posted to microsoft.public.outlook.contacts
Joseph Liu
external usenet poster
 
Posts: 1
Default Import email address in an Excel to a DL

I have an Excel file containing 100+ email addresses which belong to one DL.
How can I import them to Outlook 2003?
Ads
  #2  
Old November 17th 08, 07:06 AM posted to microsoft.public.outlook.contacts
Milly Staples [MVP - Outlook][_2_]
external usenet poster
 
Posts: 2,202
Default Import email address in an Excel to a DL

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?


  #3  
Old November 17th 08, 07:58 AM posted to microsoft.public.outlook.contacts
Joseph Liu[_2_]
external usenet poster
 
Posts: 4
Default Import email address in an Excel to a DL

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

"Milly Staples [MVP - Outlook]" wrote:

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?



  #4  
Old November 17th 08, 08:08 AM posted to microsoft.public.outlook.contacts
Gordon[_4_]
external usenet poster
 
Posts: 648
Default Import email address in an Excel to a DL

"Joseph Liu" wrote in message
...
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....

  #5  
Old November 17th 08, 01:09 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 12,991
Default Import email address in an Excel to a DL

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]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Joseph Liu" Joseph wrote in message
...
I have an Excel file containing 100+ email addresses which belong to one
DL.
How can I import them to Outlook 2003?


  #6  
Old December 16th 08, 08:18 PM posted to microsoft.public.outlook.contacts
Noel
external usenet poster
 
Posts: 26
Default Import email address in an Excel to a DL

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

"Gordon" wrote:

"Joseph Liu" wrote in message
...
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....


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import email addesses from excel into Outlook distribution list? Rod Outlook - Using Contacts 1 April 17th 08 02:57 PM
How do I import contact info from Excel into email dist list? Delrae Outlook - Using Contacts 1 August 1st 07 01:38 PM
how do i import excel address files to outlook deb999 Outlook - Using Contacts 1 September 30th 06 09:32 PM
email addresses will not import into outlook from excel Leslie325 Outlook - Using Contacts 3 August 23rd 06 04:01 PM
Can someone open my old address book in Excel and email it to me Shervision Outlook - Using Contacts 1 March 1st 06 08:21 PM


All times are GMT +1. The time now is 08:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.