How to Export Outlook Emails in a Specific Date Range to External Excel or PST Files

This article mainly looks at how to export the emails in a selected date range. Exporting to Excel files can benefit data statistics. And exporting to PST files can reduce the current using PST file size, thereby decreasing the chances of corruption.

To export emails in a specific date range to Excel files, you won’t be able to see the email contents. But you can accomplish it just via instant search. In contrast, exporting to PST files will demand more operations. Now read on to learn the concrete steps more elaborately.

Export to Excel Files

  1. To start with, in Outlook Mail pane, click in the search box.
  2. Then type “received:2016/8/20..2016/8/29” in the search box. You can change the data range as per your needs.Received Date Range
  3. After the emails in the date range appear in the mail list, select all of them. Click on one mail and press “Ctrl + A”. And right click the email and choose “Copy”.
  4. Next open MS Excel and create a new workbook.
  5. Click on the Cell A1 and press “Ctrl + C” to paste the copied search results. Soon the emails will be listed here under the same columns in Outlook.Emails listed in Excel File
  6. Finally save the workbook.

Export to PST Files

  1. At the beginning, head to “File” > “Open” > “Import”.
  2. In the dialog box of “Import and Export Wizard”, select “Export to a file” and click “Next”.Export to a file
  3. Then in “Export to a file” screen, select “Outlook Data File” and click “Next”.Export to Outlook Data File
  4. In “Export Outlook Data File” screen, select “Inbox” folder and click “Filter” button.
  5. Next in the new popup dialog box of “Filter”, switch to “Advanced” tab.
  • You should set “Fields” to “Received”. Click “Field” > “All Mail fields” > “Received”.
  • In “Conditions”, select “between”.
  • And in “Value”, you should enter “2016/8/20 and 2016/8/29” alike.
  • Lastly, click “Add to List” and press “OK” button.Specify the Date Range
  1. You will back to “Export Outlook Data File” window. Click “Next” button.
  2. Click “Browse” button to specify the location to save the exported PST file and name it.Save exported file as
  3. Eventually after clicking “Finish” button, you will see that a small dialog box pops up. It demands you to create a password for the new Outlook file. You can decide it according to your needs.Add Optional Password

Henceforth, you have exported the emails in the specific data range to a separate PST file. You can find it at your set destination folder. Deleting the exported emails in the original PST file can reduce its size, thereby reducing the possibility of PST corruption.

What to Do in Case of Outlook Crashes

Despite boasting of multiple functions, Outlook is error prone as well. Besides, it may crash without any omens. So what should do in case of crashes? Firstly, check backups. Secondly, use ScanPST to repair PST file. Lastly, if it fails, apply third party software, like DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and outlook repair software products. For more information visit

3 responses to “How to Export Outlook Emails in a Specific Date Range to External Excel or PST Files”

  1. Simply wish to say your article is as astonishing. The clarity on your submit is simply excellent and that i can assume you’re knowledgeable in this subject. Well together with your permission allow me to grab your RSS feed to stay updated with imminent post. Thanks a million and please keep up the enjoyable work.

  2. Hi, I am trying to complete the above but would like all emails between a date range of a year. Is “created” the best filter to be used instead of “received”?

Leave a Reply

Your email address will not be published. Required fields are marked *