Link to home
Start Free TrialLog in
Avatar of rivkamak
rivkamakFlag for United States of America

asked on

distribution list

i would like to create a distribution list in outlook 2007 with a large amount of emails (100 aprox).  is there a limit to how big a local dl can be?  is there a way to import a list?
Avatar of 9l1ves
9l1ves
Flag of South Africa image

Do not believe there is a limit to Distribution lists.
http://support.microsoft.com/kb/238569

in terms of importing a list. You can do this via powershell. It depends if they are contacts or already existing mailboxes.

Assuming mail contact:

Create a CSV with 3 columns: name, email and ou

Then do the following:
 
$CSVFile = "c:\users.csv"
 
Import-CSV $CSVFile | ForEach-Object -Process {New-MailContact -Name $_.name -ExternalEmailAddress $_.email -OrganizationalUnit $_.ou}
 
After that you can assign the users to the distribution group:
 
Import-CSV $CSVFile  | ForEach-Object -Process {Add-DistributionGroupMember -Identity  distributiongroupname}
Avatar of rivkamak

ASKER

they are not contacts.  just a list of names and addresses.  can it still be done?
are they mailbox users or contact users? Contacts are normally just Name and SMTP Address. That is what the above will accomplish. Mailbox users the above would need to be modified.
neither.  i have a spreadsheet of names and i want to add them to a group.
ASKER CERTIFIED SOLUTION
Avatar of Manpreet SIngh Khatra
Manpreet SIngh Khatra
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also if you are sending information to a large number of outside address, make sure you have their permissions first, otherwise for US recipients, you run the risk of violating the CANSPAM act.