Importing addresses from an Excel spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pddmcse - 21 Apr 2006 15:51 GMT

I have about 8000 email addresses in an Excel spreadsheet that need to be
imported and created into a Distribution List in MS Outlook.

The first question, is it possible and what steps do I need to follow to do
so.

The second question, will there be any impact on our Exchange Server when we
attempt to send out a simple mail to the DL?

Please advise, any help is greatly appreciated. Thanks!

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Apr 2006 08:17 GMT

A personal distribution list in an Outlook folder in an Exchange mailbox or public folder -- as opposed to a DL in Active Directory -- can hold only roughly 120 members. Why don't you just perform a mail merge using the spreadsheet as the data source?

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have about 8000 email addresses in an Excel spreadsheet that need to be
> imported and created into a Distribution List in MS Outlook.
[quoted text clipped - 6 lines]
>
> Please advise, any help is greatly appreciated. Thanks!

Reply to this Message