The "Add-DistributionGroupMember" powershell cmdlet is available in Exchange 2010. To do this ensure you can access the CSV file on one of your Exchange 2010 servers and run it on that server. On a normal client desktop "Add-DistributionGroupMember" is not available.

 

 

Check the CSV File Output:

Import-Csv .\StaffForDistGroup.csv


displayname

---------

John Doe

Bob Smith

Andy Barnes

Jane Smith

Tom Jones

Harry Best

Ben Dover

 

 

You can have various fields in the CSV file, its just important somewhere there is a displayname/samid/DN etc so it can be used to add to the group. If you dont have this like I have in the past had first name and last name fields you can just concatenate these to get the full name (which might be your display name?!).

 

 

Add the Users to the Distribution Group based on the "displayname"  field:

Import-Csv .\StaffForDistGroup.csv | ForEach {Add-DistributionGroupMember -Identity "All Staff Payroll" -Member $_.displayname}

 

 

And there you have it, all the users will now have been added to the Distribution Group.

 

 

 

Share this blog post on social media:

Social Links

Disclaimer

All advice, installation/configuration how to guides, troubleshooting and other information on this website are provided as-is with no warranty or guarantee. Whilst the information provided is correct to the best of my knowledge, I am not reponsible for any issues that may arise using this information, and you do so at your own risk. As always before performing anything; check, double check, test and always ensure you have a backup.

Copyright ©2008-2021 Andy Barnes - Please do not copy any content including images without prior consent!

Designed and Hosted by Andy Barnes

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.