Export All Email Addresses from Office 365
Want to save this blog for later? Download it now.
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 Tool.
To do this yourself, firstly connect to Office 365 using PowerShell.
Read more 
.
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
Alternatively, you can use our Office 365 reporting and management application to export a list of email addresses directly to a CSV or PDF file.
If you found this blog post useful, and want to refer to it again, why not download it as a PDF?
Related Posts
These other blog posts may be of interest to you: