Mass/bulk create user account in Active Directory with Exchange mailboxes

The easiest way is to get your new user information in a spread sheet with the following columns:

Firstname, Lastname,Aliasname,Database,OUPath

The OUPath is in the format of server\storagegroup\mailbox store

Then, use powershell to import the CSV file and create the users:

First thing you will need to do is create a password that will be used for each account (obviously you can see this so the user has to change it on logon).

$Password=Read-Host “Password” -AsSecureString

Then import the CSV file and loop through it

Import-CSV C:\CreateNewmailbox.csv |
foreach {
$userprincipalname = $_.Firstname + “.” +  $_.Lastname + “@domain.com”
new-mailbox -name $_.name -alias $_.alias -FirstName $_.Firstname -LastName $_.Lastname -userPrincipalName  $userprincipalname -database $_.Database -OrganizationalUnit  $_.OUpath -Password $Password
}