Skip to main content

How to export bulk/selected emails to Excel/Text/PST file in Outlook?

Author: Kelly Last Modified: 2020-06-09

Comparing to exporting all emails in a mail folder with the Import and Export feature in Outlook, you may just need to export the selected emails only sometimes. But how could you do? This article will introduce several solutions for you:


Export bulk/selected emails to a text file

You can easily export multiple selected emails as a single text file with the Save As feature in Outlook. Please do as follows:

1. In the Mail view, select multiple emails you will export, and click File > Save As.
Note: Holding the Ctrl key, you can select multiple nonadjacent emails with clicking them one by one; holding the Shift key, you can select multiple adjacent emails with clicking the first one and the last one.

2. In the opening Save As dialog box, (1) open the destination folder you will export the emails to, (2) type a name for the new text file in the File name box, and (3) click the Save button. See screenshot:

And now all selected emails have been exported as a single text file already.

One click to save/export multiple emails to text/PDF/HTML/CSV 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 Bulk Save feature can help you quickly save multiple email messages to individual text files, PDF files, HTML files, etc. with only one click!


ad batch save as 9.50

Export bulk/selected emails to Excel / Text / CSV / PDF files

If you have Kutools for Outlook installed, you can apply its Save as Txt feature to quickly exported multiple selected emails as individual text files in bulk.

Kutools for Outlook: Ultimate Outlook toolkit with over 100 handy tools. Try it FREE for 60 days, no limitations, no worries!   Read More...   Start Free Trial Now!

1. In the Mail view, select multiple emails you will export, and click Kutools > Bulk Save. See screenshot:
doc export bulk selected emails 01

2. In the popping out dialog, please select the Browse button to specify the destination folder you will save the emails into, check the file formats you will save the emails as, and click the Ok button.
doc export bulk selected emails 02

And now, each selected email is exported as a single text/html/word/excel/csv/pdf file into the specified destination folder.


Export bulk/selected emails to an Excel workbook

If you want to export multiple selected emails as an Excel workbook, you can copy them, and then paste in a new workbook easily.

1. In the Mail view, select multiple emails you will export, and copy them with pressing Ctrl + C keys together.

2. Launch Excel, put the cursor at Cell A1, and paste the emails with pressing Ctrl + V keys together.

3. Now all selected emails are pasted in the new workbook as below screenshot shown. Please save the new workbook.


Export bulk/selected emails to a PST file

If you want to export multiple selected emails as a PST file in Outlook, you can easily get it done with the Archive feature.

1. In the Mail view, select multiple emails you will export, right click and select Move > Copy to Folder from the context menu. See screenshot:

2. In the Copy Items dialog box, click the New button.

3. In the Create New Folder dialog box, type a name for the new folder in the Name box, specify a folder where to place the new folder, and click OK buttons successively to close both dialog boxes. See screenshot above:

4. Now all selected emails are copied to the new folder. Click File > Info > Tools > Clean Up Old Items (or File > Info > Cleanup Tools > Archive).

5. In the opening Archive dialog box, please (1) check the Archive this folder and all subfolders option, (2) click to select the new folder you have created in below list box, (3) type Tomorrow into the Archive items older than box, and then (4) click the Browse button.

6. In the Open Outlook Data Filed dialog box, please type a name for the new archive file in the File names box, and click the OK button. See screenshot:

7. Now you return to the Archive dialog box, please click the OK button, and then click the Yes button in the popping out Microsoft Outlook dialog box.

And now all selected emails have been exported as a PST file in Outlook.


Related 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 (2)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
not good for thousands emails
This comment was minimized by the moderator on the site
Hi,
Normally, you can apply the Import/Export feature to export all emails in a certain mail to a PST file, or a CSV file (you can convert it to Excel file or Text file easily).
For exporting all emails from a mail folders, you can copy the whole PST file directly. By the way, this way will also copy contacts, calendars, tasks, and other Outlook items.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations