{"id":2699,"date":"2019-01-15T20:44:08","date_gmt":"2019-01-15T20:44:08","guid":{"rendered":"http:\/\/microsoftgeek.com\/?p=2699"},"modified":"2019-01-15T20:48:06","modified_gmt":"2019-01-15T20:48:06","slug":"bulk-import-email-aliases-to-office-365-using-powershell","status":"publish","type":"post","link":"https:\/\/microsoftgeek.com\/?p=2699","title":{"rendered":"Bulk import email aliases to Office 365 using Powershell"},"content":{"rendered":"

If you need to add email aliases to O365 accts in bulk use the following (EMS)\u00a0powershell\u00a0command with the CSV file formatted this way:<\/b><\/p>\n

 <\/p>\n\n\n\n\n\n
Name<\/td>\nProxyAddresses<\/td>\n<\/tr>\n
user1@domainold.com<\/td>\nuser1@domainnew.com<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Run this in EMS:<\/b><\/p>\n

Import-Csv C:\\email-aliases.csv |\u00a0ForEach-Object{ $name = $_.Name }<\/i>\u00a0<\/span><\/p>\n

Import-Csv C:\\email-aliases.csv |\u00a0ForEach-Object{ $proxy = $_.ProxyAddresses\u00a0-split \u2018;\u2019}<\/i>\u00a0<\/span><\/p>\n

Set-RemoteMailbox\u00a0-Identity $name -EmailAddresses\u00a0@{add= $proxy}<\/i>\u00a0<\/span><\/p>\n

 <\/p>\n

OR<\/i><\/h1>\n

 <\/p>\n

Get the display name and email alias in this CSV format.<\/b><\/p>\n\n\n\n\n\n\n
mailbox<\/td>\nnewemailaddress<\/td>\n<\/tr>\n
Phyliss Ames<\/td>\npames@<\/a>email.domain.com<\/a><\/td>\n<\/tr>\n
Shelley Whitten<\/td>\nswhitten@email.domain.com<\/a><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Run in EMS:<\/b><\/p>\n

Import-CSV “C:\\staging\\aliases2.csv” |\u00a0ForEach\u00a0{Set-RemoteMailbox\u00a0-identity $_.Mailbox -EmailAddresses\u00a0@{add=$_.NewEmailAddress}}\u00a0<\/span><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

If you need to add email aliases to O365 accts in bulk use the following (EMS)\u00a0powershell\u00a0command 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 |\u00a0ForEach-Object{ $name = $_.Name }\u00a0 Import-Csv C:\\email-aliases.csv |\u00a0ForEach-Object{ $proxy = $_.ProxyAddresses\u00a0-split \u2018;\u2019}\u00a0 Set-RemoteMailbox\u00a0-Identity $name -EmailAddresses\u00a0@{add= $proxy}\u00a0   OR   Get […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,58,62,73,60,59],"tags":[],"class_list":["post-2699","post","type-post","status-publish","format-standard","hentry","category-exchange-2010","category-exchange-2013","category-microsoft-exchange-server-2016","category-exchange-server-2019","category-office-365","category-powershell"],"_links":{"self":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2699"}],"version-history":[{"count":6,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2699\/revisions"}],"predecessor-version":[{"id":2705,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/2699\/revisions\/2705"}],"wp:attachment":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}