13 May 2022

How to export a list of members of an email group from Office 365?

https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-really-export-distribution-list-members/efe355ff-cc64-4235-8615-364bbff75382

Based on my tests and researches, it is not feasible to export distribution list members using UI interface. We can only export the members via Windows PowerShell. To do that, the steps are as follows:

1. Open Windows PowerShell and connect to Exchange Online PowerShell. Here are the commands:

Install-Module ExchangeOnlineManagement (Enter Y to install the module)

Connect-ExchangeOnline (Sign in using admin account and password)

2. Then run the following script to get a csv file about Distribution list.

$Groups = Get-DistributionGroup

$Groups | ForEach-Object {

$group = $_.Name

$members = ''

Get-DistributionGroupMember $group | ForEach-Object {

$members=$_.Name

New-Object -TypeName PSObject -Property @{

GroupName = $group

Members = $members

EmailAddress = $_.PrimarySMTPAddress

}}

} | Export-CSV "C:\DistributionGroupMember.csv" -NoTypeInformation -Encoding UTF8

Here is a screenshot about the result I got:

Image


No comments:

Post a Comment