Others

How to Create a Dynamic Distribution Group for All Reports Under a Manager in Exchange

Ayan MasoodAyan Masood Nov 3, 2026 871 views

Question details

The user wants to know how to create a dynamic distribution group that includes all direct and indirect reports in a management hierarchy.

Creating a Dynamic Distribution Group for All Reports Under a Manager in Exchange
Product
Microsoft 365 / Exchange Server
Device & OS
not provided
Scenario
Managing automated email distribution lists based on the organizational management hierarchy.
Observed behavior
The user needs to find out if there is a built-in capability or rule to recursively include all direct and indirect reports of a specific manager in a dynamic distribution group.
Before you start

Ensure you have administrator privileges in the Exchange Admin Center or Microsoft 365 portal to view and manage recipient filters and distribution groups.

Solution 1Recommended

Understanding Exchange Built-in Limitations and Workarounds

Exchange Server does not natively support recursive dynamic distribution groups for all reports under a manager, but you can achieve this using custom attributes.

Microsoft Exchange dynamic distribution groups rely on standard recipient filters. Unfortunately, there is no built-in filtering rule to recursively include all direct and indirect reports (the entire downline) under a specific management hierarchy.

To achieve this functionality, administrators typically need to use PowerShell scripts to query the Active Directory hierarchy and populate a specific Custom Attribute for those users, which can then be used as the filter for the dynamic distribution group.

1
Verify available recipient filters

Log in to the Exchange Admin Center (EAC) and navigate to Recipients > Groups. Check the Dynamic distribution group settings to familiarize yourself with the available attribute filtering options.

2
Utilize Custom Attributes

Using a PowerShell script, map out the management hierarchy and assign a unique value to one of the 15 available Custom Attributes (e.g., CustomAttribute1 = 'ManagerXHierarchy') for all employees under the specific manager's downline.

3
Create the Dynamic Group based on the attribute

Set the recipient filter of your dynamic distribution group to automatically include any users who have that specific Custom Attribute value.

Understanding Exchange Built-in Limitations and Workarounds
Community Support: For advanced PowerShell scripts or Azure AD dynamic group queries, it is recommended to consult the official documentation or ask in the Microsoft Q&A Exchange Online community.
Free Microsoft Office alternative

Manage Your Organizational Data Offline with WPS Office

While WPS Office does not manage Exchange servers, it provides powerful tools like WPS Spreadsheet to help you map out management hierarchies, document Active Directory structures, and track employee attributes efficiently without the high cost of a Microsoft subscription.

  1. 1. Download and Install WPS Office: Visit the official WPS website and download the free WPS Office suite to your computer.
  2. 2. Open Your Active Directory Export: Launch WPS Spreadsheet and open your existing Microsoft Excel (.xlsx or .csv) file containing your employee hierarchy and manager attributes.
  3. 3. Map the Hierarchy: Use built-in data sorting, filtering, and pivot tables in WPS Spreadsheet to organize direct and indirect reports before scripting them into Exchange.
Free, lightweight, and easy to deploy across your organizationFully compatible with Microsoft Excel (.xlsx) formats for managing user lists and attributesBuilt-in templates for creating visual organizational chartsFamiliar user interface ensuring a seamless migration for administrative staff
microsoft office alternative - wps office

Frequently Asked Questions

Can I use the 'Manager' attribute to create a dynamic distribution group?

You can use the Manager attribute to filter for direct reports, but Exchange does not automatically perform a recursive search for indirect reports (reports of reports) using just this attribute in a standard dynamic distribution group filter.

What is the difference between a distribution group and a dynamic distribution group?

A standard distribution group requires administrators or owners to manually add or remove members. A dynamic distribution group automatically calculates its membership based on specific recipient filters and Active Directory attributes every time an email is sent to it.

Are Azure AD dynamic groups capable of hierarchical filtering?

Azure AD dynamic groups also rely on flat user attributes for their membership rules. Calculating deep direct and indirect reporting structures usually requires custom scripting or third-party identity management tools to stamp users with a common searchable attribute.