To post as a guest, your comment is unpublished.· 1 years agoso that we can organize all our emails as per our requirements
To post as a guest, your comment is unpublished.· 1 years agoActually you can custom you mail view with required columns, and then copy the emails to Excel file directly. This article may help you https://www.extendoffice.com/documents/outlook/4433-outlook-custom-fields-export.html
How to export emails by date range to Excel file or PST file in Outlook?
Let’s say you need to export emails received between 2016/4/15 and 2016/5/10 in Outlook to a separate PST file or Excel workbook, any ideas? This article introduce two workarounds to export Outlook emails to Excel workbook or PST file by date range.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.
For exporting emails by date range from Outlook to Excel, please do as follows:
1. Shift to the Mail view, and open the mail folder where you will export emails by date range.
2. Type the search criteria received:2016/4/15..2016/5/10 into the Instant Search box.
Note: received:2016/4/15..2016/5/10 means searching emails received between 2016/4/15 and 2016/5/10, and you can change the date range as you need.
3. Now all emails received in the specified date range are found out. Select all search results, right click and select Copy from the right-clicking menu. See screenshot:
Note: You can select all search results with clicking any one email in the mail list and pressing the Ctrl + A keys simultaneously.
4. Create a new workbook, select the Cell A1, and press Ctrl + V keys simultaneously to paste all search results into the new workbook.
5. Save the new workbook.
And now all emails received between the specified date range are exported to an Excel workbook.
If you need to export emails by specified date range to PST file in Outlook, please do as follows:
1. Click File > Open & Export > Import/Export (or File > Open > Import).
2. In the opening Import and Export Wizard, please click to select the Export to a file option, and click the Next button.
3. In the new Export to a File dialog box, please click to select the Outlook Data File (.pst) option, and click the Next button.
4. Now the Export Outlook Data File dialog box opens. Please click to select the mail folder which you will export emails from, and click the Filter button. See screenshot below:
5. Now in the popping Filter dialog box, please go to the Advanced tab, and specify filter criteria as:
(1) Click Filed > All Mail fields > Received;
(2) Choose between from the Condition drop down list;
(3) Type the date range into the Value box. In my case, I type 2016/4/15 and 2016/5/10 into the Value box.
(4) Click the Add to List button.
(5) Click OK > Next.
6. In the new opening Export Outlook Data File dialog box, click the Browse button to open the Open Outlook Data Files dialog box, next specify the destination folder you will place the PST file into, name the PST file in the File Name box, and then click OK > Finish.
7. In the new Create Outlook Data File dialog box, please click the OK button.
Note: If you need to add a password to the exported PST file, please type your password into both Password box and Verify Password box, and then click the OK button.
So far, we have exported the emails received in the specified date range to a separate PST file in Outlook.
Recommended Productivity Tools
- Complicated and repeated operations can be done a one-time processing in seconds.
- Forward multiple emails individually with one-click, and auto forward by rules.
- Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
- Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
- 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 years agoDo you have any plugin to export all the sender name,email subject and date from Microsoft Outlook to an excel file?