How to Get Microsoft 365 Email Activity Reports for Custom Date Ranges
Question details
Administrators need to retrieve total sent and received email counts for specific users or shared mailboxes over custom date ranges, particularly for periods exceeding one year.
- Product
- Microsoft 365
- Device & OS
- not provided
- Scenario
- Generating historical email activity reports for auditing, compliance, or user analytics.
- Observed behavior
- Standard Microsoft 365 admin center reports only provide email activity data for the most recent 180 days, preventing direct access to older historical data.
Ensure you are logged into the Microsoft 365 admin center with an account that has Global Administrator, Exchange Administrator, or Reports Reader permissions.
Generate Standard Reports for the Last 180 Days
Use the Microsoft 365 admin center to access and download standard email activity reports for recent timeframes.
Microsoft 365 provides built-in reporting tools that allow administrators to track email activity. By default, these standard reports can retrieve data for up to the last 180 days.
Log in to the Microsoft 365 admin center using your administrator credentials.
In the left-hand navigation menu, click on 'Reports', then select 'Exchange', and choose 'Email activity'.
Use the date filter options to select a custom date range within the allowed 180-day window.
Click the 'Export' button to download the report as a .csv file, which will contain the total sent and received email counts for your users and shared mailboxes.
Request Data Older Than 180 Days via Support
Since the admin center limits reports to 180 days, you must contact Microsoft Online Support to retrieve historical backend data for previous years.
Analyze Your Exported Reports Easily with WPS Office
While Microsoft 365 manages your backend email server data, you'll need a reliable tool to analyze the CSV reports you export. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office for managing all your spreadsheets and documents.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up the suite on your computer.
- 3. Open Your Reports: Launch WPS Spreadsheet to easily open, filter, and analyze the email activity CSV files downloaded from Microsoft 365.
Frequently Asked Questions
Why can't I see email activity older than 180 days in the Microsoft 365 admin center?
By default, Microsoft 365 retains and displays reporting data in the admin center for a maximum of 180 days to optimize system performance. Accessing older historical data requires a specialized backend extraction via Microsoft Support.
Who has permission to view email activity reports in Microsoft 365?
To access these reports, your account must be assigned specific administrative roles. Typically, Global Administrators, Exchange Administrators, or users with the Reports Reader role can view and export this data.
Can I analyze the downloaded email activity report offline?
Yes. Once you export the report from the Exchange admin center, it is saved locally as a .csv file. You can open and analyze this file using any compatible spreadsheet software, such as WPS Spreadsheet or Microsoft Excel.
