Bulk creation of Exchange accounts

colskinet

colskinet

colskinet

Associate
Joined
23 May 2007
Posts
25
I am in need of creating around 150-160 email accounts in Exchange 2007 in one go. Any recommendations on the best way to go about this?

Could probably have the required information in a .csv file for importing etc.

Regards
 
Are these mailboxes for existing accounts, or do you need to create new AD accounts at the same time? This TechNet article should give you some idea of what you'll need to do in either case.
 
PowerShell is your best friend here ... If they already have AD accounts, then two lines will do it for you, should be self explanatory

$mailbox=import-csv C:\Scripts\PowerShell\users.csv
ForEach ($mailbox in $mailbox) {Enable-Mailbox -Identity $Mailbox.Identity -Database $Mailbox.Database}
Click to expand...

Have two columns in your CSV. First one called Identity, second one called Database, then fill in the relevant bits

Identity .......... Database
Joe Bloggs .......... ExchangeDB1
Ben Smith .......... ExchangeDB3

etc etc
 
They are for new users who have no accounts.

I've managed to create them using PowerShell but we use a different default email address policy - our email address is setup in Exchange to be [email protected] however the system is generating the usernames as [email protected] and I don't seem to be able to change this!

Am I missing something obvious?!
 
colskinet said:
They are for new users who have no accounts.

I've managed to create them using PowerShell but we use a different default email address policy - our email address is setup in Exchange to be [email protected] however the system is generating the usernames as [email protected] and I don't seem to be able to change this!

Am I missing something obvious?!
Click to expand...

If you don't specify an email address, it will use the UPN to create it, which is usually the [email protected] which is where you might be getting the [email protected] from ... try use the ExternalEmail attribute
 
Sounds like your default address policy is not created or being applied in the correct order.

If these are existing AD accounts, just go into ESM and into Mailbox, new mailbox and it should pull up the list of all users that do not have an exising mailbox select them all next fill in the details.

Gives you very limited options but if your exchange platform is small an not complex might work out better for you.

Kimbie
 
Nikumba said:
Sounds like your default address policy is not created or being applied in the correct order.

If these are existing AD accounts, just go into ESM and into Mailbox, new mailbox and it should pull up the list of all users that do not have an exising mailbox select them all next fill in the details.

Gives you very limited options but if your exchange platform is small an not complex might work out better for you.

Kimbie
Click to expand...


Kimbie

They aren't existing users, I am creating them from scratch both in AD and assigning them email addresses.

I've been using the following command to create the mailboxes, but it's putting in the wrong email address (assuming as I'm using the UPN - I couldn't get it to work with the ExternalEmail aatribute..

Code: 
Import-Csv C:\test.csv | foreach {New-Mailbox -Alias $_.alias -Name $_.Name -UserPrincipalName $_.UPN -Database "Standard Mailbox Database" -OrganizationalUnit Engineers -Password $Password}

Even if I re-apply our default email address policy template after creating the mailbox it still seems to be leaving the email address as [email protected] as opposed to [email protected] which is what I'm after!

Regards
 
Just as a follow up to this, I ended up using a utility called ANPC (Arposh New User Creation) to import a CSV file and create accounts and then just manually added them using the "New Mailbox" feature in Exchange.

All working as intended. Also found a handy utility called ADModify.net to make a few bulk changes.
 
You must log in or register to reply here.
Back
Top Bottom