add 180 aliases to 1 365 mailbox

dougdog
dougdog used Ask the Experts™
on
add 180 aliases to 1 365 mailbox
i have 1 mailbox in o365 exchange online
i need to add 180 aliases to this 1 mailbox
i dont want to have to add each one manually
is there anyway i can add all aliases to a csv file and import?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Systems Analyst & Webmaster
Commented:
Yes you can make a CSV and then use powershell to import it - Here's a blog post showing you how to format the CSV and import it - https://www.jonamerica.com/technology/create-100s-of-email-aliases-in-office-365/
Saif ShaikhServer engineer

Commented:
Hi,

You can connect to O365 powershell with the tenant global admin credentials and run command:

Set-Mailbox mailboxname -EmailAddresses @{Add='alias@somedomain.co.uk'}  (This command is manual command)

We also have a powershell script:

Please download the script for the same from link: https://gallery.technet.microsoft.com/office/Over-200-aliases-da06ad0b

Put all the names/addresses in a list and paste it in to Excel. Then concatenate the rest of the text on to each line using copy and paste. Save it as a test file with alias_addresses.txt

From power shell with admin right you need to run below command:

E.g.:
# .\Over_200_Aliases.ps1 -O365Admin admin@xxxxxx.onmicrosoft.com -O365AdminPassword Password123 -Mailbox_Name mailbox1 -Mail_Addresses_File_Path "C:\Temp\ExoVoice\alias_addresses.txt"

Where
# O365Admin - Administrator login ID
# O365AdminPassword - Administrator login password
# Mailbox_Name - mailbox with more than 200 aliases
# Mail_Addresses_File_Path - the pathe where the file with initial addresses list is saved e.g. email_addresses.txt

Author

Commented:
William
could i just create a csv
what would my columns be
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

William FulksSystems Analyst & Webmaster

Commented:
Click the link I sent you and it gives the format. You can skip step 1 if you already have your aliases.

Author

Commented:
is this what first line should look like and do i just paste in all aliases?

Name, ProxyAddresses,;user@company.com
William FulksSystems Analyst & Webmaster
Commented:
Here's a better detailed explanation of using a CSV to import into Office 365. The CSV would be formatted as Recipientname, emailaddress, aliasemailaddress

https://o365info.com/adding-email-addresses-using-powershell-import-from-csv-file-bulk-mode-office-365-part-5-13/

Author

Commented:
perfect

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial