Create Address List in Exchange online based on Group Membership?

Question

Create Address List in Exchange online based on Group Membership?

Darryl 51

I would like to create some address lists which I know I have to do in Powershell.
How would I do this so the list is made up of users who are members of a particular group please and are only mailboxes, so no contacts etc.

Thank you.

Joyce Shen - MSFT 16,701 Reputation points

2021-10-29T02:35:23.237+00:00

Hi @Darryl

Any progress about your question? Do suggestions below from michev help?

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

4 answers

Your answer

Joyce Shen - MSFT 16,701 Reputation points

2021-10-29T02:35:23.237+00:00

Hi @Darryl

Any progress about your question? Do suggestions below from michev help?

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Vasil Michev 119.5K MVP Volunteer Moderator

You can try something like this:

New-AddressList -Name GroupBased -RecipientFilter {(MemberOfGroup -eq "CN=DG,OU=tenant.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=EURPR03A001,DC=prod,DC=outlook,DC=com") -and (RecipientType -eq "UserMailbox") -and (Alias -ne $null)}

where you need to provide the DistinguishedName value for the group.

Charles Emenugha 1 Reputation point

2022-07-21T16:56:10.627+00:00

Hi Michev,

Can I please get some guidance on your script above? I have an M365 Group with members dynamically assigned. How do I use that in the context of your script.

Thanks,

Answer 2

Darryl 51

Thanks you Michev, will take a look at that.

Darryl 51 Reputation points

2021-10-28T12:59:51.96+00:00

Hi Muchev,

Thanks for your help with this. I have made the address list and checked in Powershell that it has the right members, which it does. But its not showing in outlook just yet, assume that it will in time? #patience
Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2021-10-28T13:07:00.117+00:00

Give it at least 30 mins, and check in OWA first - Outlook might take a bit longer.
Darryl 51 Reputation points

2021-10-28T13:11:29.613+00:00

will do, thanks for your help.
Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2021-10-28T14:15:19.467+00:00

Took ~40 mins here. Also, don't forget that you might need to "touch" each recipient in order for them to appear in the new AL.
Rich Matheisen 47,901 Reputation points

2021-10-28T15:01:28.167+00:00

Are you using an offline address book in Outlook? Those types of address books are updated on a schedule, not immediately. And, if I remember correctly, Outlook only downloads an OAB once a day unless you download a new one manually.
Darryl 51 Reputation points

2021-10-28T15:51:02.423+00:00

We do have an Offline AB, but I am not looking at that one. So far after c. 2 hours seven out of 100+ users have appeared in the new Address List. Hopefully all will appear overnight.
Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2021-10-28T16:00:34.81+00:00

If you can already see the new AL, it's time to "touch" the recipients: https://learn.microsoft.com/en-US/exchange/troubleshoot/administration/new-address-lists-not-contains-all-recipients
Darryl 51 Reputation points

2021-10-29T07:09:44.153+00:00

thanks, will give that a go.

Answer 3

Darryl 51

Just to say a big thank you to everyone that has helped me with this, I've got a few more AL to create but now know exactly how this is done thanks to the contributors on here.

Have a great weekend.

Answer 4

Korbyn Forsman 5

Seems helpful, but I'm finding that the only people showing up in the Address List are accounts that are modified after created the Address List.

Still baffled as to why Update-AddressList didn't get added to Exchange Online...

Share via

Create Address List in Exchange online based on Group Membership?

4 answers

Your answer