We help IT Professionals succeed at work.

Add bulk users to Distribution Group using Powershell Cmdlet

Anthony K O365
on
8,593 Views
Last Modified: 2012-05-10
I need to add about 100 users to a distribution group in my Exchange 2010 organization. The users are in a csv file. What is the power shell command to use to import these users?

Thanks!!
Comment
Watch Question

import-csv c:\users.csv | foreach-object { add-distributiongroupmember <group> -member $_.name }

where name is the column header
Anthony K O365Messaging Consulting

Author

Commented:
I'm not sure of the columns in my csv file. Would you happen to know the column fields to provide for my csv?
post the header row and i can tell you what to use
Anthony K O365Messaging Consulting

Author

Commented:
emailaddress  firstname  lastname displayname
import-csv c:\users.csv | foreach-object { add-distributiongroupmember <group> -member $_.emailaddress }

or

import-csv c:\users.csv | foreach-object { add-distributiongroupmember <group> -member $_.displayname }

Anthony K O365Messaging Consulting

Author

Commented:
Since I'm dealing specifically with Dynamic Distribution Groups, the problem I'm having is the cmdlet is not accepting add-dynamicdistributiongroupMember. Should I not able to substitute this command?
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Anthony K O365Messaging Consulting

Author

Commented:
He was absolutely correct. I need to modify the filter

thanks

Commented:
hello,
any chance to import users from file to distribution group from csv using column number, because my csv file doesnt have headers?