Exchange Online create custom address list filter by email

berketjune2012 351

Hello

I would like to create a custom address list "New List" in Exchange online and add any users with a specific domain such as @Company portal .com in their email address.

And then verify the members of the list?

What would be the powershell command ?

Thanks

2 answers

Vasil Michev 95,341 Reputation points MVP

2021-09-22T17:42:01.82+00:00

New-AddressList, then specify the name and recipient filter to use. For example, you can use a filter like this:

((Alias -ne $null) -and (EmailAddresses -like '*@keyman .com'))

For additional details and examples, refer to the official documentation here: https://learn.microsoft.com/en-us/exchange/address-books/address-lists/manage-address-lists
Make sure you also check the section about updating lists, as in ExO this requires you to "touch" each object.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Yuki Sun-MSFT 40,856 Reputation points

2021-09-23T06:21:33.313+00:00
Hi @berketjune2012 ,

According to this official document, it's not supported to use the wildcard as a prefix for the RecipientFilter parameter in Exchange Online Powershell, so it's not feasible to use recipient filter like (EmailAddresses -like '*@keyman .com') to directly create the customized address list.

As a workaround, we can set one of the custom attribute for the mailboxes who have PrimarySmtpAddress with specific domain such as @Company portal .com, for example:

Get-Mailbox | Where{$_.RecipientType -eq 'UserMailbox' -and $_.PrimarySmtpAddress -like "*contoso.com"} | Set-Mailbox -CustomAttribute10 "DomainContoso"

Then the custom address list can be created based on the conditional custom attribute:

New-AddressList -Name "DomainContoso AddressList" -IncludedRecipients AllRecipients -ConditionalCustomAttribute10 "DomainContoso"

To view the members of the address list, run the command below:

$AL = Get-AddressList -Identity "DomainContoso AddressList"; Get-Recipient -ResultSize unlimited -RecipientPreviewFilter $AL.RecipientFilter | select Name,PrimarySmtpAddress,HiddenFromAddressListsEnabled

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.
Please sign in to rate this answer.
berketjune2012 351 Reputation points

2021-09-23T15:07:34.837+00:00

Hi @Yuki Sun-MSFT Thank you

IIs there a way to do it by Company name if the company name field is populated?

Thanks

Yuki Sun-MSFT 40,856 Reputation points

2021-09-24T06:22:48.79+00:00

Hi @berketjune2012 ,

Yes, you can do it use the Company Name by running command similar to below:

New-AddressList -Name 'TestAddressList' -RecipientFilter {(Company -eq 'CONTOSO')}

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.

berketjune2012 351 Reputation points

2021-09-24T17:38:26.343+00:00

@Yuki Sun-MSFT how can i see the members after the address list is created?

Also this is a hybrid environment. Will this process work if run on exchange online powershell?

Yuki Sun-MSFT 40,856 Reputation points

2021-09-27T01:39:46.2+00:00

Hi @berketjune2012 ,

To view the members, we can also use the commands mentioned earlier:

$AL = Get-AddressList -Identity 'TestAddressList'; Get-Recipient -ResultSize unlimited -RecipientPreviewFilter $AL.RecipientFilter | select Name,PrimarySmtpAddress,HiddenFromAddressListsEnabled

Will this process work if run on exchange online powershell?

Yes. I tested in my Exchange Online lab tenant by running the command below after connecting to Exchange Online Powershell, and it did work well:

New-AddressList -Name 'TestAddressList' -RecipientFilter {(Company -eq 'CONTOSO')}

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.

berketjune2012 351 Reputation points

2021-09-27T14:56:11.367+00:00

@Yuki Sun-MSFT when i run your commands, and check the membership in powershell, I can see all the members listed in powershell correctly.

Now the issue is, when i go to outlook office on the web and compose a new email, click the address book, I only see 5 entries in the address list instead of the full list of contacts.

Any idea why this could be happening?

Yuki Sun-MSFT 40,856 Reputation points

2021-09-29T08:02:39.27+00:00

Hi @berketjune2012 ,

Now the issue is, when i go to outlook office on the web and compose a new email, click the address book, I only see 5 entries in the address list instead of the full list of contacts.

This sounds related to the by-design behavior as mentioned in the document below:
New address lists that you create in Exchange Online don't contain all the expected recipients

Please refer to the workarounds in the above article and see if the other recipients can show up properly.

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.

Yuki Sun-MSFT 40,856 Reputation points

2021-09-30T08:16:44.77+00:00

Hi @berketjune2012 ,

Just checking in to see if you have had a chance to see the reply earlier. If the information provided was helpful, would you mind clicking "Accept Answer" under the post so that others with similar issue can benefit from the thread? Should there's any further questions or concerns on this. feel free to post back.

berketjune2012 351 Reputation points

2021-09-30T14:31:03.62+00:00

Hello I will this and get back to you shortly.

berketjune2012 351 Reputation points

2021-09-30T14:35:35.113+00:00

@Yuki Sun-MSFT if im reading this article correctly, all you have to do is assing a temp value to a custom attribute and then resync? and this could be any customattribute correct?

Also can you give me the powershell command if I want to do this to a specific list of users.

Thanks

Yuki Sun-MSFT 40,856 Reputation points

2021-10-05T04:52:45.803+00:00

Hi @berketjune2012 ,

if im reading this article correctly, all you have to do is assing a temp value to a custom attribute and then resync? and this could be any customattribute correct?

Exactly.

And regarding your query about doing this to a specific list of users, theoretically we can do it using some filters, but considering that as you mentioned, it's just a temp value to a custom attribute, so I'd suggest just following the steps in the document to do it to all users as that would be simpler.

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.
Sign in to comment