Home / server / Questions / 317122
In Process
Henno
Asked: 2011-09-30 21:33:49 +0800 CST

What is the most efficient way to create Exchange 2010 mailing list from plain text list of external email addresses?

  • 772

I need to create a new mailing list in Exchange 2010 which would consist of about 50 external email addresses. I have the list of (external) email addresses in plain text format.

I have previously solved this task by manually creating an external contact for each email address and then adding those external contacts to a distribution group.

What would be the most efficient way to solve this task with Exchange 2010? Does EMS help here?

exchange exchange-2010

2 Answers

    1. Make a CSV, c:\distro.csv with 1 column called "PrimarySmtpAddress"
    2. Make a distribution group called DistroGroup
    3. Add the contacts to the group with this code

    PowerShell Code: 

    import-csv c:\distro.csv | foreach {
    $contact = New-MailContact -Name $_.PrimarySmtpAddress -ExternalEmailAddress $_.PrimarySmtpAddress -OrganizationalUnit "Vendors" 
    Add-DistributionGroupMember -id DistroGroup -member $contact
}

    c:\distro.csv:

    PrimarySmtpAddress
[email protected]
[email protected]
[email protected]
    • 3

  2. You'll still be doing the same thing, but it's definitely a task that's made easier with a little powershell.

    You can use New-MailContact to batch-create the mail-enabled contact object, then pass a list of those new objects to New-DistributionGroup as -members.

    • 1