Today I did some experimentations with Powershell and created a script which creates mailcontacts from a CSV by importing the name, e-mail adddress and OU. When the mailcontact is created it will be added to a distributiongroup.

When you want to use the file you can just copy and paste it in Notepad and save is as a ps1 file. When you gone execute the command you need to give some parameters with it, it will looks like this:

adduserstodg.ps1 -CSVFile c:\users.csv

The easiest way is to put the file in the scripts directory from Exchange.

Complete script

[string] $CSVFile

Import-CSV $CSVFile | ForEach-Object -Process {New-MailContact -Name $\ -ExternalEmailAddress $\ -OrganizationalUnit $_.ou}

Import-CSV $CSVFile | ForEach-Object -Process {Add-DistributionGroupMember -Identity DistibutionGroupName -Member $}


Johan Veldhuis