Share via

Dealing with and extracting emails from distributions lists which contain multiple embedded distribution lists.

Anonymous
2023-12-20T12:47:07+00:00

Dear Microsoft Community,

Please help me provide a quick / efficient solution to the following action. I have a master distribution list in my Outlook GAL. This master list contains multiple embedded distribution lists and some of those DL's are comprised of several distribution lists. So effectively a layer of multiple distribution lists. We regularly need extract all contacts separately, by email address and the current process is so cumbersome, as currently I am having to one by one expand all the lists - which can take up to an hour if not more.

Please advise a quick/efficient way to complete this action? Copying and pasting emails takes a few seconds, into a csv/txt/or excel file - getting these emails is so painful.

Please advise how I can do this? We have most of the Microsoft 365 suite, so if power automate can be leveraged here, it would help operational efficiency.

Your guidance will be much appreciated.

Thank you!

Outlook | Windows | Classic Outlook for Windows | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-20T15:47:42+00:00

    Dear Laura_2022,

    Good day!

    Thank you for posting to Microsoft Community. We are glad to assist.

    As per your mentioned description about "Dealing with and extracting emails from distributions lists which contain multiple embedded distribution lists." To understand the situation and be able to offer you relevant suggestions, we would need a little more information from you. Kindly help us in providing the following information.

    • May I know if you want to extract emails address which are in Distribution List? If so, May I confirm that you checked below PowerShell command to export members from distribution list? Get-DistributionGroupMember -Identity Email | Select Name, PrimarySMTPAddress | Export-CSV "C:\Users\inema\Desktop\testDL3.csv" -NoTypeInformation -Encoding UTF8 Get-DistributionGroupMember (ExchangePowerShell) | Microsoft Learn
    • May I know your current environment? Is It Exchange Hybrid, on-premises exchange (Exchange server) or pure cloud?
    • Would you mind to kindly provide the screenshot of the outlook version are you using? Kindly go to File-->Office Account

    We look forward to your response. Kindly note that the above requested information is required for further analysis and troubleshooting of your situation. Your patience and cooperation are much appreciated. Have a nice day!

    Best regards,

    Inema | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments