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} 

 

OR

 

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}}