Solved

distribution list

Posted on 2013-06-12
8
314 Views
Last Modified: 2013-06-17
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?
0
Comment
Question by:rivkamak
8 Comments
 
LVL 5

Expert Comment

by:9l1ves
ID: 39241792
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}
0
 

Author Comment

by:rivkamak
ID: 39241883
they are not contacts.  just a list of names and addresses.  can it still be done?
0
 
LVL 5

Expert Comment

by:9l1ves
ID: 39242405
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.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:rivkamak
ID: 39245323
neither.  i have a spreadsheet of names and i want to add them to a group.
0
 
LVL 52

Accepted Solution

by:
Manpreet SIngh Khatra earned 500 total points
ID: 39250076
You can create contacts from an Excel if you have minimum details and then you will have to manually create a DL in Outlook and add contacts to it

- Rancy
0
 
LVL 23

Expert Comment

by:Brian B
ID: 39253180
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.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now