Busy Bees IT Servicedesk

$groups = Get-DistributionGroup | Where-Object {$_.Name -like "area*"}

$results = @()

foreach ($group in $groups) {

    $members = Get-DistributionGroupMember -Identity $group

    foreach ($member in $members) {

        $results += New-Object PSObject -Property @{

            Group = $group

            Email = $member.PrimarySmtpAddress

        }

    }

}

$results | Export-Csv -Path C:.\arealistjan24.csv -NoTypeInformation

WAIT FOR CSV TO GENERATE THEN:

$members = Import-Csv -Path C:.\documents\arealistjan24.csv

foreach ($member in $members) {

    Remove-DistributionGroupMember -Identity $member.group -Member $member.email -Confirm:$false

}

EDIT CSV THEN RUN BELOW:

$members = Import-Csv -Path C:.\documents\arealistjan24.csv

foreach ($member in $members) {

    Add-DistributionGroupMember -Identity $member.group -Member $member.Email

}