Export emails addresses from Office 365

[Disease]

Hi,

 

I need to get a list of emails from a particular distribution list into a CSV file from Office 365, is there an easy non-convoluted way to do this?

 

Many thanks

[djm968]

No "easy non-convoluted way" but something like this using powershell

 

Get-DistributionGroup "Distribution Group Name" | Get-DistributionGroupMember | select DisplayName,Title,PrimarySMTPAddress | Export-CSV c:\temp\filename.csv

Edited July 12, 2017 by djm968

[hallb15]

Hi,

 

I need to get a list of emails from a particular distribution list into a CSV file from Office 365, is there an easy non-convoluted way to do this?

 

Many thanks

There's an easy, but slightly convoluted way which involves expanding the list in Outlook, copying then text importing into excel using semicolons as separators, then selecting the whole row and paste special-transpose into columns.

Does that help?

[Disease]

Thanks for all the replies I found an easy non convoluted way in the end following this page:

 

export-office-365-users-to-csv-online-without-using-powershell

 

The only extra step I did was to use an advance search to produce a list of members of the group I needed.

 

Many thanks for the suggestions, helped move me in the right direction.