<div>
For single group you can use following code..<br />

<pre><code class="code-1 nolinks" id="code-20-41828638-1"><span>Set-DistributionGroup testgroup -emailaddresses @{Add='gradstudents@domain.com','gradstudents@domain.onmicrosoft.com','gradstudents@mail.domain.com'}</span>
</code></pre>
With csv file...<br />

<pre><code class="code-1 nolinks" id="code-20-41828638-2"><span>Import-csv C:\input.csv | %{Set-DistributionGroup $_.GroupName -emailaddresses @{Add=($_.Email -Split &quot;,&quot;)}}</span>
</code></pre>
Sample CSV
<pre><code class="code-1 nolinks" id="code-20-41828638-3"><span>GroupName,Email</span>
<span>&quot;Graduated students&quot;,&quot;gradstudents@domain.com,gradstudents@domain.onmicrosoft.com,gradstudents@mail.domain.com&quot;</span>
</code></pre>
Emails will be updated to group 'Graduated students'<br />
<br />
In case you if you don't have the export command..<br />

<pre><code class="code-1 nolinks" id="code-20-41828638-4"><span>Get-DistributionGroup &quot;Graduated students&quot; | Select-Object DisplayName,PrimarySmtpAddress,@{N=“Email”;E={($_.EmailAddresses |? {$_.PrefixString -ceq “smtp”} | % {$_.SmtpAddress}) -Join &quot;,&quot;}} | Export-csv C:\group.csv -nti</span>
</code></pre>
</div>


<div>
Thanks Again, I think we are close but , let me explain it more.<br />
Since I'm performing a migration &nbsp;of all the DGs managed by the exchange on premises to O365, I'm running a script that pre-creates the DG in O365 with the prefix &quot;Cloud-&quot; followed by the name of the Group to migrate. but this new pre-created group can't have the email addresses of the old one since they are still assigned to that old group. <br />
So, I'm doing <br />
<br />
Import-CSV C:\input.csv | ForEach {Get-DistributionGroup -Identity $_.name | select Displayname, emailaddresses} | Export-Csv C:\emailaddresses1.csv -NoTypeInformation<br />
&nbsp;<br />
This will give me a csv file with 2 columms :<br />
Column A= GroupName (e.g: ACE Portfolio)<br />
Column B= Emailaddresses (e.g: &nbsp;smtp:ace_port@mail.barry.e<wbr />du SMTP:ace_port@barry.edu smtp:ace_port@barryunivers<wbr />ity.onmicr<wbr />osoft.com x500:/o=ExchangeLabs/ou=Ex<wbr />change Administrative Group (FYDIBOHF23SPDLT)/cn=Recip<wbr />ients/cn=7<wbr />bba86b5543<wbr />b4192a1d12<wbr />a45115c7d9<wbr />1-ACE Portfolio X400:C=US;A= ;P=BARRYU;O=BUMAIN;S=ace?p<wbr />ort; smtp:ace_port@barrynet.bar<wbr />ry.edu)<br />
<br />
After that I delete the groups from the exchange on premises and AD and &nbsp;then After the DGs are also deleted from O365, then I should import the email addresses and remove the cloud- from the name of the group.<br />
When running your sentence adjusted to my &nbsp;names, etc.. this is the error I'm getting<br />
<br />
&quot;Cannot process argument transformation on parameter 'EmailAddresses'. Cannot<br />
convert value &quot;System.Collections.Hashta<wbr />ble&quot; to type<br />
&quot;Microsoft.Exchange.Data.P<wbr />roxyAddres<wbr />sCollectio<wbr />n&quot;. Error: &quot;MultiValuedProperty<br />
collections cannot contain null values.<br />
Parameter name: item&quot;<br />
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: InvalidData: (:) [Set-DistributionGroup], Parame<br />
&nbsp; &nbsp;terBindin...mationExceptio<wbr />n<br />
&nbsp; &nbsp; + FullyQualifiedErrorId : ParameterArgumentTransform<wbr />ationError<wbr />,Set-Distr<wbr />ib<br />
&nbsp; &nbsp;utionGroup<br />
&nbsp; &nbsp; + PSComputerName &nbsp; &nbsp; &nbsp; &nbsp;: ps.outlook.com&quot;<br />
<br />
Looks like it can't read it in the format i have it...
</div>


<div>
Thanks Subsun, but the file exported has empty the column for Email. Only the DisplayName is populated with the Groups.
</div>


<div>
Just tested, It's working for me.. Does the group shows result for following command<br />

<pre><code class="code-1 nolinks" id="code-20-41828737-1"><span>Get-DistributionGroup TestGroup | select Displayname,@{N=“Email”;E={($_.EmailAddresses |? {$_.PrefixString -eq “smtp”} | % {$_.SmtpAddress}) -Join &quot;,&quot;}}</span>
</code></pre>
If above fails, please post the result for..<br />

<pre><code class="code-1 nolinks" id="code-20-41828737-2"><span>Get-DistributionGroup TestGroup | select -exp EmailAddresses</span>
</code></pre>
</div>


<div>
Hi Subsun,<br />
I had to work on something else. I'll test this tonight and I'll let you know tomorrow. Thanks for all your help . I really appreciate it.
</div>


<div>
The first one failed. It doesn't shows anything on the email part. Just empty.<br />
The second one Works this way:<br />
<br />
PS C:\Users\XXXXXX&gt; Get-DistributionGroup &quot;ACE Orlando&quot; | select -exp EmailAddresses<br />
SMTP:ace_orlando@barry.edu<wbr /><br />
smtp:ace_orlando@mail.barr<wbr />y.edu<br />
smtp:ace_orlando@barryuniv<wbr />ersity.onm<wbr />icrosoft.c<wbr />om<br />
x500:/o=ExchangeLabs/ou=Ex<wbr />change Administrative Group (FYDIBOHF23SPDLT)/cn=Recip<wbr />ients/cn=7<wbr />6dcb5395be<wbr />b4525b89e8<wbr />3e450035a<br />
82-ACE Orlando<br />
X400:C=US;A= ;P=BARRYU;O=BUMAIN;S=ace?o<wbr />rlando;<br />
smtp:ace_orlando@barrynet.<wbr />barry.edu
</div>


<div>
Is that the exact result you get in powershell console?<br />
<br />
Can you test this command and see result?
<pre><code class="code-1 nolinks" id="code-20-41828996-1"><span>Get-DistributionGroup TestGroup | select Displayname,@{N=“Email”;E={($_.EmailAddresses |? {$_ -match “smtp”} | % {($_ -split &quot;:&quot;)[1]}) -Join &quot;,&quot;}}</span>
</code></pre>
</div>


<div>
DisplayName &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Email<br />
&nbsp;ACE Orlando &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ace_orlando@barry.edu,ace_<wbr />orlando@ma<wbr />il.barry.e<wbr />du,ace_orl<wbr />...<br />
&nbsp;This one looks good &nbsp;with emails separated by coma..<br />
Thank you Subsun
</div>


<div>
Ok you can use the same to export the list..<br />

<pre><code class="code-1 nolinks" id="code-20-41829867-1"><span>Import-CSV C:\input.csv | ForEach {Get-DistributionGroup -Identity $_.name | select Displayname,@{N=“Email”;E={($_.EmailAddresses |? {$_ -match “smtp”} | % {($_ -split &quot;:&quot;)[1]}) -Join &quot;,&quot;}} | Export-Csv C:\emailaddresses1.csv -NoTypeInformation</span>
</code></pre>
</div>


<div>
Looks like it should work but is stays like this:<br />
<br />
PS C:\Users\gallo&gt; Import-CSV S:\egallardo\test.csv | ForEach {Get-DistributionGroup -Identity $_.name | select Displayname,@{N=&quot;Email&quot;;E=<wbr />{($_.Email<wbr />Addresses |? {$_ -match &quot;smtp&quot;} | % {($_ -split &quot;:&quot;)[1]}) -Join &quot;,&quot;}} | Export-Csv S:\egallardo\Migration\ema<wbr />iladdresse<wbr />s2.csv -NoTypeInformation<br />
&gt;&gt;<br />
&gt;&gt;<br />
And file emailaddresses2.csv is not created.<br />
&nbsp;I even reduce the amount of DGs in test.csv &nbsp; to 19 and still....nothing.it wont come out of that state...<br />
&nbsp;I had to ctrl+C &nbsp;to get out of that state.
</div>


<div>
Yes, That was it , perfect , Now it is created with that format , separated by coma only .<br />
So to later import them into the pre-created ones in O365:<br />
1- Delete from O365 those DGs that I already have pre-created them in O365 and also their email addresses exported.<br />
2.-Remove the Cloud- prefix to that list of pre-created DGs<br />
3.- Now I'm doing : Import-csv S:\Migration\emailaddresse<wbr />s2.csv | %{Set-DistributionGroup -Identity $_.Displayname -emailaddresses @{Add=($_.Email -Split &quot;,&quot;)}} &nbsp; &nbsp; &nbsp; (As you suggested) &nbsp;And Is working Just Fine. <br />
I just need to find a better way now to remove the Cloud- and to reassign the correct email address as the one to use to reply. But I'll try to find it by my self, So far you have Helped me A LOT!!!<br />
Thank you So much &nbsp;Subsun
</div>


<div>
Susbsun,is the Best, Always replied quickly, and he was helping me all the way until the correct sentence was created. And all that at any time, You guys rock!!!!
</div>


<div>
<div class="content wysiwyg-content">
Hi ,<br />
I have a csv file with with the email addresses used by a DG. NOT the email address from the members of the DG , I'm referring to the smtp addresses used by the DG. For Instance: if the DG name is &quot;Graduated students&quot; with email addresses like: &nbsp;gradstudents@domain.com , gradstudents@domain.onmicr<wbr />osoft.com,<wbr /> gradstudents@mail.domain.c<wbr />om...<br />
I need a sentence to import those email addresses into another DG in O365.<br />
Thanks,
</div>
</div>


Hi ,
I have a csv file with with the email addresses used by a DG. NOT the email address from the members of the DG , I'm referring to the smtp addresses used by the DG. For Instance: if the DG name is "Graduated students" with email addresses like:  gradstudents@domain.com , gradstudents@domain.onmicrosoft.com, gradstudents@mail.domain.com...
I need a sentence to import those email addresses into another DG in O365.
Thanks,

Import  emailaddresses, exported from a distribution Group, to another DG

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.