Bulk Create Mail Users

Question

My company has several hundred alias that need to be created that forward out to another mail system.  I know I can create full mailboxes in bulk via the interface on O365 but there's no option to bulk create mail users in the Exchange admin center. 

Is there a way to complete this via a CSV file and powershell commands?

Answer 1

Hi Rob,

Based on my test, you can bulk create mail users in Office 365 referring to these steps:

1. Create a new .csv file with these columns included and add the corresponding mail users’ information:

Name    ExternalEmailAddress    MicrosoftOnlineServicesID    Password

2. Connect to Exchange Online PowerShell
3. Run this script to import the .csv file:

$users = Import-Csv (folder path of the .csv file)

$users | ForEach-Object {

New-MailUser -Name $_.Name -ExternalEmailAddress $_.ExternalEmailAddress -MicrosoftOnlineServicesID $_.MicrosoftOnlineServicesID -Password (ConvertTo-SecureString -String '$_.Password' -AsPlainText -Force)}

NOTE: You should replace (folder path of the .csv file) with the real folder path value.

If you encounter any errors running the cmdlets above, please feel free to take a relevant screenshot of the error message and upload it for our further analysis.

Regards,

Sam

Answer 2

Hi Rob,

No. Please follow the Sam's suggestion and use those columns listed above ( Name    ExternalEmailAddress    MicrosoftOnlineServicesID    Password)to create the .csv file. 

If you encounter any issues or errors during the process, please capture a relevant screenshot of the scenario for further troubleshooting.

Thanks,

Lance

Answer 3

Everything worked in my test environment, thank you very much!

Answer 4

Thanks for the quick response, I'll not be able to test right now but will by this time tomorrow.  Is there a specific format for the CSV file?