Bulk import (csv) external contacts to a specific distribution list (365)

Copper Contributor

Hi there,

 

I would like to bulk import external contacts/recepients (e.g. gmails etc) using a csv file to a specific distribution list named colleagues that I have already created.

 

I found this article:

https://docs.microsoft.com/en-us/microsoft-365/compliance/bulk-import-external-contacts?view=o365-wo...

 

but it's about bulk importing external contacts in general not in a specific distribution list.

 

Any ideas?

 

Thank you in advance.

6 Replies

Run the steps in the article to provision the contacts objects in your directory. Once that's done, you can add them all to a DG. Something like this should do:

 

Import-CSV blabla.csv | % { Add-DistributionGroupMember DG -Member $_.Emailaddress }

 

where the csv file is named blabla.csv and it contains a column "emailaddress" to designate the external contact.

Thank you @Vasil Michev .

May I ask you two things considering the:
Import-CSV blabla.csv | % { Add-DistributionGroupMember DG -Member $_.Emailaddress }

1) Where should I write the distribution list name whereI want to add the emails ?
2) I guess before the blabla.csv I have to type the path, right?

Thank you again.

In the above, "DG" is the name of the group, you can also provide an email address. And yes, use the full path to the CSV file.

@Vasil Michev 

 

I just tried that, it doesn't work

the contacts must already exist in exchange to be added in the distribution list