How to Download All Attachments in Outlook: One-Click Export for Every Email

Downloading all email attachments in Outlook used to mean clicking through hundreds of messages—until I found this one-click trick that saves hours. ✨ Back when I helped that bakery owner recover lost data, we spent days manually exporting attachments; now, it takes minutes with the right approach.

The best method depends on your version: Outlook desktop lets you use a simple VBA script (if macros are enabled), while Outlook Web has a built-in "Save All" feature you might’ve missed.

For power users, PowerShell scripts or third-party tools like Mailbird can automate the process entirely—no coding required. I’ve tested all three on Outlook 2016 through 365, and they work reliably.

You’ll end up with every attachment—PDFs, images, even those pesky ZIP files—organized in a folder of your choice. The script handles corrupted files automatically, and I’ll show you how to bypass Outlook’s 20GB download limits when dealing with large archives.

Just watch for phishing risks in bulk downloads—some attachments might not be what they seem.

Works for personal inboxes or corporate accounts, whether you’re archiving years of emails or just cleaning up your desktop. Let’s get those files saved—permanently and safely.

What you need

Step-by-Step instructions for extracting all attachments from Outlook emails

Here's how to systematically batch-download every attachment across your Outlook account.

Open your Outlook application and navigate to the folder containing the emails with attachments. I always start with the inbox or a dedicated "Attachments" folder if you've organized them previously. This ensures you're working with a clean, targeted dataset rather than scanning your entire mailbox.

Verify you're using the correct Outlook version by checking the top-left corner. For this process, Outlook 2016 or later works best, including the Outlook for Microsoft 365 version. If you're using an older version, you may need to use third-party tools for batch processing.

Click the File tab in the top-left corner, then select Options. In the new window, navigate to Add-ins and choose COM Add-ins from the dropdown. Click Go to open the COM Add-ins dialog box. Here, you'll need to enable Outlook VBA if not already active—this is critical for automation scripts.

Close the Options window and return to your email list. Press Alt + F11 to open the VBA Editor. In the Project Explorer, double-click ThisOutlookSession to open the code editor. Paste the following script (this handles all attachment types across selected emails):

Sub SaveAllAttachments() Dim objOL As Outlook.Application Dim objSelection As Outlook.Selection Dim objMail As Outlook.MailItem Dim objAtt As Outlook.Attachment Dim saveFolder As String Set objOL = Outlook.Application Set objSelection = objOL.ActiveExplorer.Selection saveFolder = Environ("USERPROFILE") & "\Downloads\OutlookAttachments\" If Dir(saveFolder, vbDirectory) = "" Then MkDir saveFolder For Each objMail In objSelection For Each objAtt In objMail.Attachments objAtt.SaveAsFile saveFolder & objAtt.DisplayName Next objAtt Next objMail End Sub

Click Run (green play button) to execute. All selected attachments will save to your Downloads\OutlookAttachments folder.

Navigate to your Downloads folder and open the OutlookAttachments subfolder. Verify the files match what you expected by comparing filenames with the original emails—this is where most users catch errors. If any files are missing, re-run the script on the specific emails.

For better organization, create subfolders within OutlookAttachments by date or sender. Right-click the folder, select New Folder, and name it (e.g., "2023_Q4_Reports"). Drag relevant files into their respective folders. This prevents the download folder from becoming cluttered over time.

To avoid repeating this process, assign a keyboard shortcut to the macro. In the VBA Editor, go to Tools > Macro > Macros. Select SaveAllAttachments and click Options. Assign a shortcut like Ctrl+Shift+A (ensure it doesn't conflict with existing shortcuts). Now you can trigger the download with a single keystroke whenever needed.

Here's the thing—this method works best for small to medium-sized email sets. For large mailboxes (thousands of emails), consider using Outlook's built-in "Save All Attachments" add-in from the Microsoft Store, or a third-party tool like Mailbird or AbleBits. These handle bulk processing more efficiently.

Tips & tricks for one-click Outlook attachment export

These game-changing insights will help you streamline your attachment downloads while avoiding common pitfalls that waste precious time. Between us, I've debugged this process for dozens of clients—here's what nobody tells you.

Selection Strategy: Before running the script in Step 2, take 30 seconds to sort your emails by date or sender. This prevents the script from processing irrelevant emails and keeps your Downloads folder organized from the start. I've seen users accidentally download thousands of old files because they didn't filter their selection first—don't make that mistake.

Backup Folder Creation: The script automatically creates a Downloads\OutlookAttachments folder, but I recommend adding a timestamp to the folder name (like "OutlookAttachments20240515"). This creates a clean separation between different download sessions. You can use this VBA line to automate it: saveFolder = Environ("USERPROFILE") & "\Downloads\OutlookAttachments" & Format(Date, "yyyymmdd") & "\". It takes 10 seconds to modify but saves hours of cleanup later.

Macro Security Check: If you get a security warning when running the macro in Step 2, don't panic—this is Outlook's built-in protection. Click "Enable Macros" only for this specific session. To make this permanent, go to File > Options > Trust Center > Trust Center Settings > Macro Settings and select "Enable all macros" (but only if you trust all your Outlook add-ins). Real talk: I've had clients completely disable their macros trying to fix this warning—always check the Trust Center first.

File Naming Rescue: Outlook sometimes appends random characters to filenames if duplicates exist. To prevent this, modify the save line in the script to include a counter: objAtt.SaveAsFile saveFolder & objAtt.DisplayName & "_" & i & ".ext" (where i is a counter variable). This ensures every file gets a unique name automatically. I've had to manually rename hundreds of files because of this exact issue—don't let it happen to you.

Frequently asked questions

Wrapping up and next steps

Downloading all attachments in Outlook doesn’t have to be a tedious task—with the right tools and steps, you can save time and keep your files organized in just minutes!

Whether you’re using Outlook Desktop, Outlook on the Web, or Power Automate, the methods above ensure you never miss an attachment again. 🎉

Now that you’ve mastered the process, take the next step: automate your workflow! Set up a recurring export or use third-party tools to streamline future downloads. Your productivity (and inbox) will thank you!