Chat with us, powered by LiveChat

Blog

Back

Export All Email Addresses from Office 365

11 Apr 2013 by Emma Robinson

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 Optimizing PowerShell for large Office 365 tenants.

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 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: