18 August 2024
02 September 2023
Microsoft 365: Export Distribution List Members to CSV Using Powershell
How to Connect to Exchange Online Using Powershell
But in practice, there is a much more simple way - Open web Outlook. Compose a new email. Click 'To'. Go to GAL. Search for the name of the distribution list. Click the plus sign.
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: