Once the data is in Excel, you can easily filter, sort, or create reports to track communication frequency and response times.
Method 1: Copy-paste trick
1. Select target folder
2. Ctrl+A o select all emails. Allow a few moments for Outlook to process the selection (especially for large folders), then press Ctrl + C to copy
3. Paste to an Excel workbook, please note that emails received in current week will have incorrect date data.
Method 2: Outlook Export
Select: File -> Open & Export -> Import/Export.
Select: Export to a file -> Next.
Select "Comma Separated Values" -> Next.
Select target Folder -> Next.
Select destination local folder and name the exported file=>Next
In the last pop-up, select “Map Custom Fields...” to re-map the column names, or just click “Finish”
The result:
Nhận xét
Đăng nhận xét