Bulk add extra smtp with prefix

Question

Bulk add extra smtp with prefix

Rune Oksnes 21

We are still on prem exchange 2016.

I need to bulk add one extra smtp with prefix like something.alias@keyman .com
I would also point this to on OU in AD
My default email address policy ia pointing to all exchange users, so I would like to avoid that.

I looked into:

Get-User -OrganizationalUnit "OU" | % { Set-Mailbox $.UserPrincipalName -EmailAddresses @{add="$("something").$($.FirstName).$($_.LastName)@keyman .com"}}

But we are using æ,ø and å here so that was not the way.

I tried to replace ($.FirstName).$($.LastName) with ($_.alias), but since that is an exchange attribute, no success.

Anyone got input to me? Is there a way to get-mailbox selected from OrganizationalUnit and return with something.alias@keyman .com?

Thank you in advance

AlexC 246 Reputation points

2021-06-04T09:35:23.773+00:00

Hello Rune,
not sure, if this is just a typo or copy/paste error, but when pipng to foreach (%), you need to use the "this" variabe "$".
Means:
Get-User -OrganizationalUnit "OU" | % { Set-Mailbox $.UserPrincipalName -EmailAddresses @{ add="smtp:something.$($.FirstName).$($.LastName)@keyman .com" } }

And there is a limitation to valid characters in the smtp local part.
A very good explanation here:
https://social.technet.microsoft.com/Forums/exchange/en-US/69f393aa-d555-4f8f-bb16-c636a129fc25/what-are-valid-and-invalid-email-address-characters
a nice table here: https://www.jochentopf.com/email/chars.html
if you prefer WIkiPedia with examples and references:
https://en.wikipedia.org/wiki/Email_address

I hope, this helps!
Cheers, Alex
AlexC 246 Reputation points

2021-06-04T09:39:01.11+00:00

ok, I just realize that the dash "_" is being removed from the code when clicking submit... too bad...
so in words, this would be like:
Dollar Dash Dot <propertyname>

Accepted answer

0 additional answers

Your answer

AlexC 246 Reputation points

2021-06-04T09:35:23.773+00:00

Hello Rune,
not sure, if this is just a typo or copy/paste error, but when pipng to foreach (%), you need to use the "this" variabe "$".
Means:
Get-User -OrganizationalUnit "OU" | % { Set-Mailbox $.UserPrincipalName -EmailAddresses @{ add="smtp:something.$($.FirstName).$($.LastName)@keyman .com" } }

And there is a limitation to valid characters in the smtp local part.
A very good explanation here:
https://social.technet.microsoft.com/Forums/exchange/en-US/69f393aa-d555-4f8f-bb16-c636a129fc25/what-are-valid-and-invalid-email-address-characters
a nice table here: https://www.jochentopf.com/email/chars.html
if you prefer WIkiPedia with examples and references:
https://en.wikipedia.org/wiki/Email_address

I hope, this helps!
Cheers, Alex
AlexC 246 Reputation points

2021-06-04T09:39:01.11+00:00

ok, I just realize that the dash "_" is being removed from the code when clicking submit... too bad...
so in words, this would be like:
Dollar Dash Dot <propertyname>

Answer 1

AlexC 246

Hi Rune,
sure, just exchange Get-User by Get-Mailbox .. you can filter for -OrganizationalUnit too, but then can use the .Alias property for the syntax above.
Alex

Rune Oksnes 21 Reputation points

2021-06-04T10:30:14.48+00:00

Thank you, closing in here now. But is there any chance of replacing ($.FirstName).$($.LastName)@keyman .com" with $($.alias)@keyman .com"
That would be my voila!
feelin uncertain since I now enter both the Exchange part and the Active Directory part, and the alias will not be piped from the get-user part.
Do not misunderstand, your answer works out fine, but we have Æ.Ø and Å in our names, that is risky business. Øyvind or Åge is not equal to what is the currently alias, where we use oyvind or Age.
Rune Oksnes 21 Reputation points

2021-06-04T11:57:08.093+00:00

ahhhhhh. a second brain is underrated. Thank you very much!
AlexC 246 Reputation points

2021-06-04T12:03:45.477+00:00

very welcome!
my second brain / memory extension for cmdlets is learn.microsoft.com .. ;o)

Share via

Bulk add extra smtp with prefix

0 additional answers

Your answer