Bulk import email aliases to Office 365 using Powershell

If you need to add email aliases to O365 accts in bulk use the following (EMS) powershell command with the CSV file formatted this way:


Name ProxyAddresses
user1@domainold.com user1@domainnew.com


Run this in EMS:

Import-Csv C:\email-aliases.csv | ForEach-Object{ $name = $_.Name } 

Import-Csv C:\email-aliases.csv | ForEach-Object{ $proxy = $_.ProxyAddresses -split ‘;’} 

Set-RemoteMailbox -Identity $name -EmailAddresses @{add= $proxy} 




Get the display name and email alias in this CSV format.

mailbox newemailaddress
Phyliss Ames pames@email.domain.com
Shelley Whitten swhitten@email.domain.com


Run in EMS:

Import-CSV “C:\staging\aliases2.csv” | ForEach {Set-RemoteMailbox -identity $_.Mailbox -EmailAddresses @{add=$_.NewEmailAddress}} 



Leave a Reply

Your email address will not be published. Required fields are marked *