How to Create a Dynamic Distribution Group for All Reports Under a Manager in Exchange
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.

- 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.
Ensure you have administrator privileges in the Exchange Admin Center or Microsoft 365 portal to view and manage recipient filters and distribution groups.
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.
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.
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.
Set the recipient filter of your dynamic distribution group to automatically include any users who have that specific Custom Attribute value.

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. Download and Install WPS Office: Visit the official WPS website and download the free WPS Office suite to your computer.
- 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. 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.

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.




