How to Download All Attachments in Outlook: One-Click Export for Bulk Files

Here’s how to download all attachments in Outlook—your inbox’s hidden treasure trove of receipts, contracts, and project files—that I’ve been meaning to organize. ✨ The "Save All Attachments" feature in Outlook Desktop cuts that task from hours to minutes, and I’ve used it to rescue entire email archives. threads before.

Whether you’re cleaning up a cluttered inbox or archiving old work, this method works faster than manually dragging files.

The process is straightforward but has a few hidden gotchas. You’ll need to pick a destination folder (I recommend a dedicated "Attachments Archive" on your desktop) and handle large files—Outlook caps attachments at 2GB per file.

For bigger collections, I’ve split them into smaller batches to avoid errors. The desktop version handles this smoothly, while the web app forces manual downloads, which is a major pain point.

You’ll end up with all attachments neatly saved in one place, ready for backup or sorting. I’ve organized mine by year and project type, which makes future searches a breeze.

The VBA method for power users adds automation, but for most people, the built-in tool does the job without extra hassle.

For those with hundreds of emails, test the process on a small folder first—some attachments might be corrupted or locked. If you hit snags, I’ll cover the fixes in the next section, including how to bypass permission errors and handle duplicate filenames automatically.

What you need

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

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

First, ensure you're working with a complete copy of your mailbox. Open Outlook and navigate to File > Open & Export > Import/Export. Select Export to a file and choose Outlook Data File (.pst) as the format. This creates a backup you can reference if needed.

I always recommend exporting to a PST file before bulk operations—it preserves the original data structure and prevents accidental deletions. Save the file to your desktop or a dedicated folder for easy access during the attachment extraction process.

Press Alt + F11 to open the VBA editor. In the Project Explorer, double-click ThisOutlookSession to open the code window. Paste this script exactly as written:

Public Sub SaveAllAttachments()
Dim objOL As Outlook.Application
Dim objNamespace As Outlook.Namespace
Dim objFolder As Outlook.MAPIFolder
Dim objItem As Object
Dim objAttachment As Outlook.Attachment
Dim strSaveFolder As String

Set objOL = Outlook.Application
Set objNamespace = objOL.GetNamespace("MAPI")
strSaveFolder = Environ("USERPROFILE") & "\Desktop\OutlookAttachments\"

' Create folder if it doesn't exist
If Dir(strSaveFolder, vbDirectory) = "" Then
MkDir strSaveFolder
End If

' Process each folder
For Each objFolder In objNamespace.Folders
ProcessFolder objFolder, strSaveFolder
Next
Set objOL = Nothing
End Sub

Private Sub ProcessFolder(objFolder As Outlook.MAPIFolder, strSaveFolder As String)
Dim objSubFolder As Outlook.MAPIFolder
Dim objItem As Object
Dim objAttachment As Outlook.Attachment

' Process current folder
For Each objItem In objFolder.Items
If objItem.Attachments.Count > 0 Then
For Each objAttachment In objItem.Attachments
objAttachment.SaveAsFile strSaveFolder & objItem.EntryID & "_" & objAttachment.FileName
Next
End If
Next

' Process subfolders
For Each objSubFolder In objFolder.Folders
ProcessFolder objSubFolder, strSaveFolder
Next
End Sub

This script recursively processes every folder in your Outlook profile and saves attachments to your desktop in a dedicated folder. The naming convention uses the item's EntryID to prevent filename conflicts.

With the VBA editor still open, press F5 to execute the macro. You'll see a progress indicator as Outlook processes each email. For large mailboxes, this may take 10-30 minutes—don't interrupt the process.

Once complete, navigate to your desktop and open the OutlookAttachments folder. Here's where it gets interesting: the files are organized by Outlook's internal item IDs, not folder structure. I recommend using Windows Search to filter by file type (.pdf, .docx, etc.) or renaming files with a more logical naming convention using bulk rename tools like Bulk Rename Utility.

Open a few sample attachments to verify they open correctly. Pay special attention to PDFs and Excel files—these formats often trigger security prompts during bulk operations. If you encounter corrupted files, they typically appear in the same folder as their working counterparts.

After verification, you can safely delete the original PST file if you no longer need it. The attachments in your desktop folder now represent a complete, searchable archive of all your email attachments. For additional organization, create subfolders matching your original Outlook folder structure.

Tips & tricks for Outlook attachment extraction

These insider techniques will help you navigate the process smoothly and avoid common pitfalls that can turn a simple task into a headache.

Backup Strategy: Before running the VBA script in Step 2, I recommend creating a second backup of your PST file. Store one copy on an external hard drive and another in cloud storage like OneDrive or Google Drive. This triple-layer protection ensures you won't lose your data if something goes wrong during the extraction process. The 10-30 minute runtime makes this small precaution worth the peace of mind.

VBA Editor Shortcut: Instead of navigating through menus to open the VBA editor, use the keyboard shortcut Alt + F11 as mentioned in Step 2. For even faster access, create a desktop shortcut to outlook.exe /safe which opens Outlook in safe mode with only basic functionality—perfect for running macros without any distractions. This saves valuable time when you're working with large mailboxes.

File Organization Hack: After the attachments save to your desktop folder, use Windows PowerShell to automatically organize them by file type. Open PowerShell and run: Get-ChildItem -Path "C:\Users\YourName\Desktop\OutlookAttachments" | Group-Object Extension | ForEach-Object {New-Item -ItemType Directory -Path "C:\Users\YourName\Desktop\OutlookAttachments\$($.Name)" -Force; Move-Item $.Group.FullName -Destination "C:\Users\YourName\Desktop\OutlookAttachments\$($.Name)"}. This creates subfolders for each file type (.pdf, .docx, etc.) automatically.