Back to blog

Export All Email Addresses from Office 365

Apr 11, 2013 by Emma Robinson

We were recently asked how to export all email addresses from an Office 365 tenant. This needed to include all email addresses on Contacts, Distribution Groups, User Mailboxes and Shared Mailboxes.

If you wanted all of this information at the touch of a finger you should try out our Office 365 reporting software.

To do this yourself, firstly connect to Office 365 using PowerShell.

Then paste in this cmdlet.
Get-Recipient -ResultSize Unlimited | select DisplayName,RecipientType,EmailAddresses | Export-Csv email-recipients.csv
This will export all the email addresses into a CSV file that you can open with Microsoft Excel.

Email Addresses in Excel

Email Addresses in Excel

Alternatively, you can use our Office 365 management software to export a list of email addresses directly to a CSV or PDF file.