Need to change multiple Aiases in Exchange using a .csv, can't make it work

Question

Need to change multiple Aiases in Exchange using a .csv, can't make it work

Jon 96

Hi,

I really hope someone can assist here as Exchange Shell is not my forte!

All I need to do is change a load of Aliases in Exchange using a .csv - The two columns in the .csv are Mail and Alias. I can change a single one using the command set-mailbox XXX.XXX@X .com -alias AB123.

As soon as I import the .csv either importing it separately or importing it in the same command line, everything errors horribly.

Does anyone have any idea what I can run to get this working? I've tried quite a few things:

Import-csv "c:\scripts\aliases.csv" | foreach {Get-MailContact -Identity $.Name | Set-MailContact -Alias $.Alias}

[PS] C:\Windows\system32>$csv= "C:\scripts\aliases.csv"
[PS] C:\Windows\system32>foreach ($mailbox in $csv) {get-mailbox -identity $mailbox.Mail | set-mailbox -alias $mailbox.Alias}

ANY help here would be greatly appreciated!

Andreas Baumgarten 129.4K Reputation points MVP Volunteer Moderator

2021-10-26T10:48:42.097+00:00

Hi @Jon ,

could you please use the "Code Sample" option (the icon with the 101010 in the icon bar of the editor) to post the commands/the script. The Q&A editor is screwing up the code if posted as normal text.
It would be helpful as well if you could post the error messages here as well.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Jon 96

Import-CSV "C:\scripts\Aliases.csv" | ForEach {Set-Mailbox $_.Mail -Emailaddresses @{add=$_.Alias}}

Answer accepted by question author

0 additional answers

Your answer

Andreas Baumgarten 129.4K Reputation points MVP Volunteer Moderator

2021-10-26T10:48:42.097+00:00

Hi @Jon ,

could you please use the "Code Sample" option (the icon with the 101010 in the icon bar of the editor) to post the commands/the script. The Q&A editor is screwing up the code if posted as normal text.
It would be helpful as well if you could post the error messages here as well.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten
Jon 96 Reputation points

2021-10-26T10:51:38.673+00:00

Import-CSV "C:\scripts\Aliases.csv" | ForEach {Set-Mailbox $_.Mail -Emailaddresses @{add=$_.Alias}}

Answer 1

Jon 96

Ok, so this is embarrassing but at least I learnt something!

It appears the issue was with the .csv, even though I had checked it before copying it to the server, it was blank and also had the wrong column names in it, I know, weird and makes no sense!

I would have thought I was going crazy if it was not witnessed by a colleague!

So, after checking the .csv on the server, importing it and running the code, it worked!

Share via

Need to change multiple Aiases in Exchange using a .csv, can't make it work

0 additional answers

Your answer