How to Export a List of Mail Items Within Folders (Exchange/O365)

This quick, easy to follow guide will help you to export a CSV file listing all of the mail items within their respective folders and sub-folders. This script will work on both Exchange and O365.

To get started in O365, you’ll need to open a remote powershell session:




$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $o365cred -Authentication Basic -AllowRedirection


Import-PSSession $session


Then run this script to export to a file:


get-mailboxfolderstatistics -identity | select FolderPath, FolderSize, ItemsinFolder, ItemsInFolderandSubfolders | Export-csv example.csv


That’s it, you’re done!