Creating groups of phone numbers for sms in exchange

what is the most efficient way to create a distribution group and populating the group with external phone numbers for text messages.  I tried creating the group via the emc  i could not copy paste the phone numbers. I tried via the exchange management console The phone numbers below is a sample. We have approx. 180 groups to create. We have about a thousand phone number to enter in Exchange. Because they are external phone number would I have to create mail contacts - which I cannot copy paste phone numbers


8192908476@txt.bell.ca
8192947097@txt.bell.ca
8192958701@txt.bell.ca
8192958721@txt.bell.ca
8192958734@txt.bell.ca
8192958743@txt.bell.ca
8192958752@txt.bell.ca
8192979378@txt.bell.ca

  • # Are you saying, you want add this external list to each DG?

    # Now I am doing this from memory as I am no where near my exchange server
    # So, test is a safe location first.

    # You could try...
    # Load the Exchange cmdlets for use in the ISE on the Exchange server

    Add-PSSnapin -Name Microsoft.exchange*

    <#
    The cmdlet load could be done on any remote client as well using the following..
    (
        Well, as long as PowerShell Remoting is enabled on teh Exchange server
        And you had permissions to use it
        And you were the Exchange administrator
    )
    #>

    $ExchangeServerFqdn = 'cas01.exchange.lab.com'

    ExchangeSession = New-PSSession `
    -ConfigurationName Microsoft.Exchange `
    -ConnectionUri "http://$ExchangeServerFqdn/PowerShell" `
    -Authentication Kerberos -Credential $ResourceAdministrator
    Import-PSSession $ExchangeSession


    # The DG part
    #
    # Create a new DG
    Import-Csv -Path "$env:SystemDrive\Files\NewDgGroupNames.csv" `
    | ForEach {New-DistributionGroup -Type Distribution -Name $NewDgGroupName}


    forEach ($NewDgGroupName in (Import-Csv -Path "$env:SystemDrive\Files\NewDgGroupNames.csv" ))
    {
        # Add a new member to DG
        forEach ($NewContact in (Import-Csv -Path "$env:SystemDrive\Files\NewContactNames.csv"))
        {Add-DistributionGroupMember -Identity $NewDgGroupName -Member $NewContact}
    }