How to Export Group Members List from Office 365: Trusted & Authorized Methods

How to export group members list from Office 365 will be explained in this article. As a result, let’s get started right away!! There is aslo a complete article on how to Backup Office 365 email mailbox

When the amount of data in a Microsoft 365 mailbox grows significantly, the user is obligated to create a backup of the account’s data. Associated accounts can also be backed up by the Administrator. Because Microsoft 365 subscription includes many apps, Microsoft Teams features a feature called Microsoft 365 Groups that preserves some important data, which the user must back up. However, getting the Group’s data directly is difficult, and the user must also retrieve information about the Group’s own and members.

What is the definition of a Distribution Group?

Distribution Groups (also known as Distribution Lists) in Office 365 allow you to send emails or meeting requests to a group of people (both internal and external users) without having to add each email address separately each time. When you need to send information to a group of people, such as “those in the sales department” or “all employees at your organization,” Distribution Groups are ideal.

How Do I Form a Distribution Group?

It’s never easy to figure out who belongs to which Distribution Group. Members of Distribution Groups can be viewed through Microsoft 365 Admin Center, but only per user. As a result, you must click each organization to view its membership, which takes time. Don’t be concerned! PowerShell, your ally, has arrived to save the day. You can Export office 365 distribution group members to CSV file using PowerShell commands.

Office 365 has Distribution List Constraints

You should be aware of a few limitations that apply to Office 365 distribution groups:

• A distribution list should have 100,000 persons on it. (50,000 for AAD Connect-enabled enterprises, 15,000 for DirSync-enabled organisations).
• A single user/admin can establish up to 300,000 groups.
• Number of owners of distribution groups: 10.
• Maximum message size for groups of 5,000-99,999 members is 25MB.

The restrictions apply to all Office 365 subscriptions, regardless of whether you have an Office 365 Business Essentials or an Office 365 Enterprise E5 subscription. Only if you have Exchange Online as a stand-alone option makes a difference. In this scenario, instead of 300,000 distribution groups, each plan permits one user to create up to 250.

How to Export Group Members List from Office 365 by Manual Methods

PowerShell Scripts- This approach requires technical expertise in executing PowerShell scripts because it involves running scripts for the export process. It indicates that a new user may struggle to run the scripts on their first attempt and will require some prior training to perform properly and achieve the intended results.

Exchange Admin Center Console- This second method is straightforward and does not necessitate a high level of expertise to perform. Users must, however, pay attention and follow the procedures in the correct order. It involves using the built-in features of the Exchange Admin Center console, such as exporting distribution group members to CSV format.

With this quick overview of the two manual methods on how to add members to distribution list in outlook 365, you should be able to decide which way to use first. But, without making any distinctions, we’ll go over the procedures involved in both systems one by one.

1. How to Export Group Members List from Office 365 Using PowerShell Script

Running Windows PowerShell as an administrator is required, followed by connecting Exchange Online to PowerShell using the commands below. Here is How to export distribution list members from office 365 using PowerShell

• To connect Exchange Online to Windows PowerShell, run the first command.
  Set-ExecutionPolicy RemoteSigned
• The next command to execute is.
  $UserCredential = Get-Credential

This command would prompt you to input your Office 365 account login details in a pop-up window. Give it to us and then click OK.

• This command will connect you to the session.
  $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic –AllowRedirection
• To connect Exchange Online to Windows PowerShell, use the following command.
  Import-PSSession $Session –DisableNameChecking

The Exchange Online is successfully configured within Windows PowerShell after this last command is done. To export a distribution group, run the commands and scripts listed below.

• Run this command to learn about the available distribution groups in your Office 365 business.
  Get-UnifiedGroup -ResultSize Unlimited

The output of this command is a list of all the Office 365 groups in the company. Here you can see which groups are necessary for export.

• Now that you’ve learned about the groups, you’ll need to learn about their members before exporting. Use the command below to do so.
  Get-UnifiedGroup -ResultSizeInfinite Get-UnifiedGroup -ResultSizeInfinite Get-Un

As a result, you’ll get access to the list of group members.

• Note: Users can run the following script to get a list of all members from all Office 365 Distribution Groups for the account.
  Groups = Get-UnifiedGroup -ResultSize Unlimited
  $Groups | ForEach-Object {
  $group = $_Get-UnifiedGroupLinks -Identity $group.Name -LinkType Members -ResultSize Unlimited | ForEach-Object {
  New-Object -TypeName PSObject -Property @{
  Group = $group.DisplayName
  Member = $_.Name
  EmailAddress = $_.PrimarySMTPAddress
  RecipientType= $_.RecipientType
  }}}

• Run this cmdlet after you’ve determined which distribution group members you wish to export to a CSV file.
  Get-DistributionGroupMember -Identity | Select Name, PrimarySmtpAddress | Export-csv members.csv –NoTypeInformation

It will export the members of the distribution group to a CSV file with information such as DisplayName, Group Primary SMTP Address, Member Email, Member’s Type, Group Alias, Group Type, Group Owner (Managed By), Members Count, Members, and so on.

• Use this PowerShell script to convert members of all Office 365 groups to a CSV file format.
  $Groups = Get-UnifiedGroup -ResultSize Unlimited
  $Groups | ForEach-Object
  {
  $group = $_Get-UnifiedGroupLinks -Identity $group.Name -LinkType
  Members -ResultSize Unlimited | ForEach-Object
  New-Object -TypeName PSObject -Property @
  Group = $group.DisplayName
  Member = $_.Name
  EmailAddress = $_.PrimarySMTPAddress
  RecipientType= $_.RecipientType
  }}} | Export-CSV “C:\\Office365GroupMembers.csv” -NoTypeInformation -Encoding UTF8

2. How to Export Group Members List from Office 365 Using Exchange Admin Center

You can export office 365 distribution group members to CSV from the Exchange Admin Center. To export O365 Groups to CSV, follow the instructions below.

• When you log in to Exchange Admin Centre, the left pane will show you, Recipients.
• Select Recipients > Groups from the drop-down menu.
• Select the distribution group you want to export from the Group tab. Select Export data to a CSV file from the More menu.
• Select the column name and click Export in the Export data window that appears on the screen.
• As a result, exporting Microsoft 365 Groups to CSV is simple.

Office 365 Backup Wizard- Automated Method

As addition as backing up mailboxes to PST, DataHelp Software Office 365 Backup Wizard lets users restore mailboxes from PST back into Microsoft 365. As well as backing up and restoring mailboxes, Microsoft 365 Groups can also be backed incredibly, it allows you to selectively backup Microsoft 365 mails depending on several criteria, such as date ranges, mailbox types.

Steps to Backup Outlook 365

1:- Office 365 Backup Software can be download and open.

2:- Take a backup of Office 365 categories.

3:- Fill in the Admin Email ID and Application ID fields.

4:- Selected Export Option can be used to backup Office 365 Email.

Conclusion for How to Export Group Members List from Office 365

The article discussed how the program simplifies the process of export all distribution list members from office 365 with membership. You can save the backup in a PST file after the software accesses the data in the Groups. The backup technique has no limitations, and you can afterwards restore the PST file to your Microsoft 365 account.