Exchange Server TechCenter >
Exchange Server Forums
>
Admin
>
How can I add members to a new distribution group from a CSV file?
How can I add members to a new distribution group from a CSV file?
- I'd like to import users from a CSV file to a Distribution Group. I've exported the members of an exisiting Distribtution Group to the CSV and I basically want to clone it with a different name. I can't get the Powershell to work...
I thought it should look like
Import-Csv -Path D:\ml.csv | ForEach-Object {Add-DistributionGroupMember....this is where I'm lost....
Orange County District Attorney
Answers
- Exchange Server 2003 does not have this cmdlet or an similar function. If you want to use PowerShell and you are using Exchange 2003, you could probably use the Quest Active Directory Powershell tools
http://www.quest.com/powershell/activeroles-server.aspx
You would need to install the PowerShell and then install the Quest tools. Then take a look at the Add-QADGroupMember cmdlet that Quest provides.
Jim McBee - Blog - http://mostlyexchange.blogspot.com- Marked As Answer byAmit TankMVP, ModeratorMonday, July 06, 2009 2:29 AM
- Hey Sandy,Try below cmdlet to import from CSV file...Import-CSV FileName.csv | ForEach {Add-DistributionGroupMember -Identity "DG Name" -Member $_.Name}In filename.csv file should have a column Name and the values must be in anyone of below format to add them as a member...GUID distinguished name UPN LegacyExchangeDN Domain\Account Name SMTP AddressAdd-DistributionGroupMember
Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com- Marked As Answer bySandy Wood Thursday, March 19, 2009 2:15 PM
- Proposed As Answer byAmit TankMVP, ModeratorThursday, March 19, 2009 6:06 AM
All Replies
- Hey Sandy,Try below cmdlet to import from CSV file...Import-CSV FileName.csv | ForEach {Add-DistributionGroupMember -Identity "DG Name" -Member $_.Name}In filename.csv file should have a column Name and the values must be in anyone of below format to add them as a member...GUID distinguished name UPN LegacyExchangeDN Domain\Account Name SMTP AddressAdd-DistributionGroupMember
Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com- Marked As Answer bySandy Wood Thursday, March 19, 2009 2:15 PM
- Proposed As Answer byAmit TankMVP, ModeratorThursday, March 19, 2009 6:06 AM
Good job, Amit
I tested in the lab
Step 1: Export Value of the user object you want to add into DG (Distribution Group)
Csvde -r objectclass=user -d "OU=ExTeam,DC=contoso,DC=com" -l "Name" -f C:\member.txt
Step 2: Import the file as Amit said
import-csv C:\member.txt | foreach {add-distributiongroupmember DGName -member $_.Name}
Step 3: Verify the result via EMC or EMS
- Thanks again Amit. We gave it a try and it worked perfectly.
Orange County District Attorney - My pleasure Sandy... :)
Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com - Hi Amit,
how can i do this on exchange 2003?
I now that add-distributiongroupmember - is exchange 2007 cmdlet and is don't work on 2003.
10x - Exchange Server 2003 does not have this cmdlet or an similar function. If you want to use PowerShell and you are using Exchange 2003, you could probably use the Quest Active Directory Powershell tools
http://www.quest.com/powershell/activeroles-server.aspx
You would need to install the PowerShell and then install the Quest tools. Then take a look at the Add-QADGroupMember cmdlet that Quest provides.
Jim McBee - Blog - http://mostlyexchange.blogspot.com- Marked As Answer byAmit TankMVP, ModeratorMonday, July 06, 2009 2:29 AM
- WOW
Jim thx, it work Perfect!!! :)
Thanks - The Quest tools are great. I use them on all of my E2K3 servers (that I wish I could migrate to E2K7) :-)
Jim McBee - Blog - http://mostlyexchange.blogspot.com Exchange Server 2003 does not have this cmdlet or an similar function. If you want to use PowerShell and you are using Exchange 2003, you could probably use the Quest Active Directory Powershell tools
http://www.quest.com/powershell/activeroles-server.aspx
You would need to install the PowerShell and then install the Quest tools. Then take a look at the Add-QADGroupMember cmdlet that Quest provides.
Jim McBee - Blog - http://mostlyexchange.blogspot.com
Hi Amit,I have 100+ DL's & need to add 15-30Users a memeber of it, can you please let me know how do i achieve this with VB script & a input file as csv
The CSV file will be GroupName, DN,GroupType, Memebers (User Sam A/c) with clon seperated.
Thanks
Rocks
