Adding External contacts to a Distribution List in Office365


As a community person i run a lot of discussion lists (in Exchange called distribution list) and always adding new people to these lists.

In the Exchange Admin interface this takes to separate steps and filling out several fields of metadata . The two separate steps are:

1.  Adding the contact

image

2.  Adding that contact to the distribution group

 

These two steps can easily take 2-3 minutes and if you have 100 people to  add……..

Turns out Exchange doesn’t need the contacts added, just an email address but the Exchange Admin UI does allow this…Luckily their PowerShell cmdlet does!

The script is really easy too!

 

 

$credential = get-credential

#Creates an Exchange Online session
$ExchangeSession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $credential -Authentication Basic -AllowRedirection

#Import session commands
Import-PSSession $ExchangeSession 

Add-DistributionGroupMember -Identity "PUG" -Member chass@messengeruser.com

 

 

Of course this could be written  as a for-each loop reading a CSV file,  but i found in many cases using Excel to create the Command works better for trouble shooting etc.

Since there are only two parameters the Excel function is very straight forward:

 

="Add-DistributionGroupMember -Identity "& B2 & " -Member " & A2

image

All i have to do is paste in the email address I want to add and autofill the rest!

 

 

 

h


Comments (1)

  1. I was wrong and had to do it with two passes the first to add them to my contacts with:
    New-MailContact -Name “Fname Lname” -ExternalEmailAddress Emailaddress.com

Skip to main content