How to run a report in outlook that tells me how many emails each day my team members receive for work tracking purpose

Hello Saikiran_chubb,

Good day! Thanks for posting in Microsoft Community. We are happy to assist you.

Based on your description I understand you want run a report in Outlook to check how many emails each day your team members receive for work. Please note Outlook does not have a built-in feature to generate detailed reports about how many each team member receives on a daily basis.

To check for reports on emails received by users you can check in Microsoft 365 admin center or using PowerShell. For detailed steps please see Microsoft 365 admin center activity reports - Microsoft 365 admin | Microsoft Learn, and this is the PowerShell command Get-MailboxStatistics -Identity user@example.com -StartDate "2023-08-01" -EndDate "2023-08-15" | Select-Object DisplayName, TotalItemCount.

As a workaround in Outlook, you can export the email data to Excel for further analysis.

• Open Outlook.
• Select the mailbox folder you want to analyze (e.g., Inbox).
• Use the "Search" or "Filter" functionality to narrow down emails for specific team members and date ranges.
• Select the filtered emails.
• Go to the "File" menu.
• Choose "Options" > "Advanced."
• Scroll down to the "Export" section and click on "Export."
• Follow the prompts to export the selected emails to an Excel file.
• In Excel, you can use features like PivotTables and charts to analyze the data and get an overview of email volume over different days.

We look forward to hearing from you. Thank you for your cooperation.

Sincerely,

Simbarashe | Microsoft Community Moderator

I'd also be interested in if there is a way to export the time stamp of a email

The exported csv using 'export' option doesnt seem to have a date time stamp, so i cant aggregate the emails by day, subject etc.. Can you please suggest a workaround or advice ?

Does outlook offer a reporting of when an email hits the Inbox, how long it takes for a user to open it and reply to it?

If emails are deleted does it report them too? Can the report be run from the deleted items?