Using Notepad.exe to create a users.csv file

ID, FullName,LastName,FirstName,Password
MAnderson, Mike Anderson,Adnderson,Mike,a
FRogers,Fergal Rogers,Rogers,Fergal,a
MWill,Mary Will,Will, Mary,a

Exchange Management Shell

$data=import-csv users.csv

Create a script file addmailboxes.ps1

$data=import-csv users.csv
$database="ex20071\Mailbox database"
$ou="work.com/Test OU"

ForEach($i in $data)
{

$ss = ConvertTo-SecureString $i.password –AsPlaintext –Force

$upn = $i.id + “@work.com”
New-Mailbox –Password $ss –Database $database -UserPrincipalName $upn –name $i.fullname –OrganizationalUnit $ou –SamAccountName $i.id –FirstName $i.firstName –LastName $i.lastname –Displayname $i.fullname

}

Run the addmailboxes.ps1 in Exchange Management Shell;

Get-MailboxFolderStatistics -id 'James.Bond' | Select Identity,FolderSize, ItemsInFolder, NewestItemReceiveDate | Export-CSV c:\Bond.csv

get-user | select Lastname, FirstName,Phone|export-csv c:\userlist.csv

batch execution

$u=(get-user -id Rob.Prince).identity;get-group -filter { members -eq $u}

Home