Forum Discussion

CptNemo's avatar
CptNemo
Copper Contributor
May 23, 2020

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

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-worldwide

 

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

 

Any ideas?

 

Thank you in advance.

  • 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.

    • CptNemo's avatar
      CptNemo
      Copper Contributor

      Thank you VasilMichev .

      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.

Resources