Skip to main content

How to export search results in Outlook to PST/Excel file?

For example, you need to find out emails from external senders in Outlook, and then export all found emails as an Excel file or PST file. Any good ideas? Itโ€™s easy to search external emails with Advanced Find feature in Outlook, but how to export? Try below workarounds:

One click to save/export multiple emails (or searching results) to text files in bulk in Outlook

Normally we can export/save an email message as a text file with the Save As feature in Outlook. But, for batch saving/exporting multiple emails to individual text files, you have to manually handle each message one by one. Time-consuming! Tedious! Now, Kutools for Outlook's Save as Txt feature can help you quickly save multiple email messages to individual text files with only one click!


save messages as text files

Office Tab - Enable Tabbed Editing and Browsing in Microsoft Office, Making Work a Breeze
Kutools for Outlook - Boost Outlook with 100+ Advanced Features for Superior Efficiency
Boost your Outlook 2021 - 2010 or Outlook 365 with these advanced features. Enjoy a comprehensive 60-day free trial and elevate your email experience!

arrow blue right bubble Export search results to PST file in Outlook

In fact, there is no direct way to export search results which you find out by Advanced Find feature or Instant Search feature in Outlook. However, we can filter emails with the same criteria as search criteria when exporting. Please do as follows:

1. Click File > Open & Export > Import/Export (or File > Open > Import) to open the Import and Export Wizard.

2. Now in the Import and Export Wizard, please click to highlight the Export to a file option and click the Next button.

3. In the Export to a File dialog box, please click to highlight the Outlook Data File (.pst) option, and click the Next button.

4. Now you get into the Export Outlook Data File dialog box, please click to select the folder you will search emails within, and click the Filter button. See screenshot below:

5. In the popping up Filter dialog box, please specify the filter criteria same as the search criteria, and then click the OK > Next buttons. See screenshot above:
Note: In my case, I specified the filter criteria on the Advanced tab with below steps: (1) Click Field > All Mail fields > From; (2) Choose doesnโ€™t contain from the Condition drop down list; (3) Type the internal domain into the Value box; (4) Click the Add to List button.

Note: If you need to export emails meeting one of multiple criteria, such as emails received on or before 2015/1/1 or on or after 2016/7/1, you need to enable the Query Builder to specify two search criteria.

Here I recommend you to quickly enable the Query Builder by Kutools > Options > check the Restore "Query Builder" tab in Outlook Advanced Find dialog option, which is supported by Kutools for Outlook. See screenshot:
ad query builder 1
And then specify the complex search criteria on the Query Builder tab in the Filter dialog box as below screenshot shown:
ad query builder 2

6. In the new Export Outlook Data File dialog box, please click the Browse button to open the Open Outlook Data File dialog box, next specify the destination folder you will place the exported PST file into, name the PST file in the File name box, and then click OK > Finish. See screenshot below:

7. The Create Outlook Data File dialog box comes out, and please click the OK button to close it.

Note: If you want to add password to the exported PST file, please type the password into both Password box and Verify Password box, and click the OK button.

Up to now we have exported all emails meeting the search criteria as a PST file in Outlook.


arrow blue right bubble Export search results in Outlook to Excel file

If you need to export all search results in Outlook to a separate Excel workbook, please follow below steps:

Note: If you can search emails with the Instant Search feature, please type the search criteria in the Instant Search box, and then copy all search results to workbook with Step 5-7.

1. Shift to the Mail view, click to open the mail folder where you want to search emails, and click Folder > New Search Folder.

2. In the New Search Folder dialog box, please click to highlight the Create a custom Search Folder option, and click the Choose button. See screenshot:

3. In the popping up Custom Search Folder dialog box, please name the new search folder in the Name box, and click the Criteria button. See screenshot:

4. Now in the Search Folder Criteria dialog box, please specify the criteria same as the search criteria and click OK > OK > OK to close all dialog boxes.
Note: In my case, I specified the criteria on the Advanced tab with following steps: (1) Click Field > All Mail fields > From; (2) Choose doesnโ€™t contain from the Condition drop down list; (3) Type the internal domain into the Value box; (4) Click the Add to List button.

5. Go ahead to open the new search folder, select and copy all emails in the search folder. See screenshot:
Notes: (1) For selecting all emails in one mail folder, please click any one email in the folder, and then press Ctrl + A keys simultaneously; (2) Press Ctrl + C keys at the same time to copy selected emails.

6. Create a new workbook, select the Cell Al and press Ctrl + V keys simultaneously to paste the search results into the new workbook.

7. Save the new workbook.

So far, we have exported all searching results to an Excel file already.


arrow blue right bubbleRelated Articles


Best Office Productivity Tools

Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook

๐Ÿค– AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

๐Ÿ“ง Email Automation: Out of Office (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

๐Ÿ“จ Email Management: Easily Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

๐Ÿ“ Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

๐ŸŒŸ Interface Magic: ๐Ÿ˜ŠMore Pretty and Cool Emojis   /  Boost Your Outlook Productivity with Tabbed Views  /  Minimize Outlook Instead of Closing ...

๐Ÿ‘ One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  ๐Ÿ•˜Show Sender's Time Zone ...

๐Ÿ‘ฉ๐Ÿผโ€๐Ÿคโ€๐Ÿ‘ฉ๐Ÿป Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Over 100 Features Await Your Exploration! Click Here to Discover More.

Read More       Free Download      Purchase
 

 

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations