Hi @santh00 ,
Can you access your import your Distribution Lists via Active Directory rather than Exchange - e.g. Da
Luckily, this is really easy in Excel 2016. Built into Excel 2016 is PowerQuery and one of the out-of-box connectors is Active Directory. With a bit of PowerQuery magic, you can easily pull this data out.
So we want to:
- Connect to our Active Directory
- List out all our Groups
- Filter to email-able Groups
- the group owner
- the members
- any security \ restrictions on who can email the list
Note: If your unluckily enough to be running an old version of Excel, it possible to do the same thing in Power BI Desktop, which is a free download.
ngers of distribution lists | Matt40k
I have also found a similar psot, please refer to it to see if it helps you.
Solved: Connect to an Outlook distribution list - Power Platform Community (microsoft.com)
If it does not help, please provide more details.
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.