How to Download All Attachments in Outlook: One-Click Export Without Missing Files

To download all attachments in Outlook, you don’t need to click through hundreds of emails—there’s a foolproof method that saves them all in one go. ⚡ I’ve used this myself when recovering client files from years of backups, and it cuts hours of manual work down to minutes.

The secret lies in Outlook’s built-in "Save All" feature, which skips the tedious drag-and-drop process while ensuring no file gets left behind.

The process works the same for Outlook 2016, 2019, and 365, though the steps for Outlook on the Web are slightly different. You’ll need access to the emails (no permission issues) and enough storage space—10GB+ for large archives.

The best part? No third-party tools or scripts required unless you’re dealing with 10,000+ attachments, where automation like VBA scripts shines. I’ll walk you through both methods so you can pick what fits your workflow.

Once you’ve exported everything, organizing those files becomes the next challenge. I recommend creating a folder structure by year or client right away—trust me, you’ll thank yourself later when you’re searching for that one invoice from 2020.

For massive downloads, cloud storage like OneDrive or Google Drive can be a lifesaver, letting you access files from anywhere without clogging your local drive.

Common pitfalls include corrupted files (always verify a few) or missing attachments (double-check filters). If you hit a snag, I’ve included troubleshooting steps for each method—like adjusting file size limits or fixing permission errors.

By the end, you’ll have a clean, searchable archive of every attachment, ready for backup or analysis.

What you need

Step-by-step instructions for exporting all email attachments in Outlook

Here's the foolproof method I use to batch-save every attachment—no manual clicks required.

Open Outlook and navigate to File > Options. In the left panel, select Customize Ribbon. Check the box for Developer in the right-hand panel, then click OK. This unlocks the Visual Basic Editor, which we'll use for the export script.

If you don't see the Developer tab after enabling it, restart Outlook. The tab appears at the top ribbon next to View—you'll know it worked when you see Macros and Visual Basic options.

With the Developer tab visible, click Visual Basic to open the editor. Go to Insert > Module and paste this code exactly as written:

Sub ExportAllAttachments() Dim olApp As Outlook.Application Dim olNs As Outlook.Namespace Dim olFolder As Outlook.MAPIFolder Dim olMail As Outlook.MailItem Dim olAtt As Outlook.Attachment Dim strFolderPath As String strFolderPath = "C:\OutlookAttachments\" On Error Resume Next Kill strFolderPath & "." MkDir strFolderPath On Error GoTo 0 Set olApp = Outlook.Application Set olNs = olApp.GetNamespace("MAPI") Set olFolder = olNs.GetDefaultFolder(olFolderInbox) For Each olMail In olFolder.Items If olMail.Attachments.Count > 0 Then For Each olAtt In olMail.Attachments olAtt.SaveAsFile strFolderPath & olAtt.DisplayName Next olAtt End If Next olMail MsgBox "All attachments exported to: " & strFolderPath, vbInformation End Sub

Close the editor and run the macro by clicking Macros in the Developer tab, selecting ExportAllAttachments, then clicking Run. All attachments will save to C:\OutlookAttachments—create this folder first or the script will fail.

Open the C:\OutlookAttachments folder to confirm all files appear. If some are missing, check the macro's error handling—corrupted attachments may skip silently. For a cleaner structure, modify the script to include subfolders by email sender.

Here's the thing—this exports everything, including duplicates. To deduplicate, use Windows Search to find .pdf or .xlsx files, then merge them manually. For large volumes, third-party tools like AttachExtractor handle this automatically.

Return to the Developer tab and click Macros again. Select ExportAllAttachments, then click Options. Check Store macro in Personal Macro Workbook and Security by Access. Click OK.

Now create a custom button: Go to File > Options > Quick Access Toolbar. Choose Macros from the dropdown and add ExportAllAttachments. The button will appear at the top ribbon—click it anytime to re-export all attachments instantly.

Tips & tricks for perfect Outlook attachment exports

These insider tricks will help you streamline your attachment exports and avoid common pitfalls that can leave files behind or cause errors.

Backup Your Outlook Data First: Before running any VBA macro, I always recommend creating a backup of your Outlook data file (.pst). Navigate to File > Open & Export > Import/Export and select Export to a file. This single step protects you from potential data corruption if something goes wrong during the export process. Trust me on this—recovering lost emails is far more painful than a few extra clicks.

Folder Path Best Practices: The default path C:\OutlookAttachments works, but I suggest creating a subfolder structure to organize by date. Modify the script's strFolderPath line to include a dynamic date stamp like strFolderPath = "C:\OutlookAttachments\" & Format(Date, "yyyy-mm-dd") & "\". This creates automatic folder organization without any extra effort on your part.

Security Considerations: When storing macros in your Personal Macro Workbook (Step 4), be aware that Outlook may prompt you about security settings. If you see warnings about macros, go to File > Options > Trust Center > Trust Center Settings > Macro Settings and select Enable all macros temporarily just for this process. Remember to reset this to a safer setting afterward—security by access is crucial for protecting your system.

Handling Large Volumes: For users with thousands of emails, the default macro might take several minutes to run. To optimize performance, consider adding Application.Wait commands between batches. For example, insert Application.Wait Now + TimeValue("00:00:01") after the inner loop to give Outlook a brief pause. This prevents freezing and makes the process more manageable for large mailboxes.

Frequently asked questions

Wrapping up and next steps

Mastering the art of downloading all attachments in Outlook is a game-changer—whether you're decluttering your inbox, backing up critical files, or preparing for a major project. 🎉 With the right tools and steps, you can save time, avoid missing files, and keep your workflow seamless.

Now that you’ve got the know-how, take that next step: try it out today and experience the freedom of a tidy, organized email system!

Still have questions? Check our FAQs or revisit the steps to fine-tune your process. Happy organizing! 🚀