18 November 2022
21 June 2022
14 May 2022
How to get a list of the members of an email distribution list, and a list of the members of an office 365 team?
13 May 2022
How to export a list of members of an email group from Office 365?
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: