none
How do you export O365 Distribution List to csv with contact information? RRS feed

  • Question

  • How do you export O365 Distribution List to csv with contact information (email address, mailing address, telephone numbers etc.)
    Sunday, September 9, 2018 2:50 AM

All replies

  • Hi,

    refer to the below link:

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_o365admin-mso_dep365-mso_o365b/how-do-i-export-office365-distribution-groups-and/4058e10c-04cc-4df7-bc1e-4235f2a2d4ee

    or you can use the below command,

    Get-DistributionGroup -ResultSize Unlimited | Export-Csv <Export File Path.CSV>;

    Now, if you'd like to narrow down the exported attributes to just "Display Name" and "Managed By" , you can add the "Select" switch.

    Get-DistributionGroup -ResultSize Unlimited | Select DisplayName,ManagedBy | Export-Csv <Export File Path.CSV>;

    You can add more attributes separated with a comma to the "Select" part as you wish.

    Best regards,

    Please Mark if the post is helpful

    Sunday, September 9, 2018 9:16 AM
  • Hi mrv1993,

    If you only need to export the information of the Distribution lists, you may refer to the command shared by Rafiul or export the data to CSV via Exchange Admin Center:

    If you are looking for how to export the information of members in an Office 365 distribution list, based on my test, you can try using the following command:

    Get-DistributionGroupMember -Identity "GroupName" -ResultSize unlimited | Select Name, PrimarySmtpAddress, Phone | Export-csv members.csv -NoTypeInformation

    Reference:

    Exporting distribution groups FROM office 365

    Hope this can be helpful.

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, September 10, 2018 7:29 AM
    Moderator
  • Hi mrv1993,

    Just checked in to see how everything is going on with the issue. If the reply above was useful, could you please help mark it as answer so that others who might have a similar question can benefit from your thread? Thanks for your understanding and support.

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Proposed as answer by Prem P Rana Saturday, September 15, 2018 11:46 AM
    Friday, September 14, 2018 5:32 AM
    Moderator