How to automatically download/save attachments from Outlook to a certain folder?
Generally speaking, you can save all attachments of one email with clicking Attachments > Save All Attachments in Outlook. But, if you need to save all attachments from all received emails and receiving emails, any ideal? This article will introduce two solutions to automatically download attachments from Outlook to a certain folder.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013 and 2016.
This method will introduce a VBA script, and run this scrip with a rule to automatically download and save Outlook attachments to a certain folder. Please do as follows:
1. Press Alt + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and then paste below VBA script into the new opening Module window.
VBA: Auto Save Outlook Attachments into a certain folder
Public Sub SaveAttachmentsToDisk(MItem As Outlook.MailItem) Dim oAttachment As Outlook.Attachment Dim sSaveFolder As String sSaveFolder = "C:\Users\DT168\Documents\outlook-attachments\" For Each oAttachment In MItem.Attachments oAttachment.SaveAsFile sSaveFolder & oAttachment.DisplayName Next End Sub
Note: Please find out sSaveFolder = "C:\Users\DT168\Documents\outlook-attachments\", and replace the destination folder’s path as you need.
3. Save the VBA Script and close the Microsoft Visual Basic for Applications window.
4. Go to the Mail view, and click Home > Rules > Manage Rules & Alerts. See screenshot:
5. In the opening Rules and Alerts dialog box, please click the New Rule button on the E-mail Rules tab. See screenshot:
6. Now in the Rules Wizard dialog box, please click to select the Apply rule on messages I receive option, and click the Next button.
7. In the Rules Wizard (which condition(s) do you want to check?) dialog box, please uncheck any option, and click the Next button. And then click the Yes button in the popping up Microsoft Outlook dialog box. See screenshot:
8. Now in the Rules Wizard (what do you want to do with the message?) dialog box, please: (1) Check the run a script option; (2) Click the text of a script to open the Select Script dialog box, select the script we added in Step 2 and click the OK button; (3) Click the Next button.
9. In the Rules Wizard (Are there any exceptions?) dialog box, please click the Next button directly.
10. Now in the last Rules Wizard dialog box, please name the rule in the Step 1 box, check options as you need in the Step 2 section, and click the Finish button.
11. Close the Rules and Alerts dialog box.
And now all attachments are downloaded from your email account and saved into the specified destination folder. And all attachments of incoming emails will be automatically downloaded and saved into the specified folder too.
If you have Kutools for Outlook installed, you can apply its Auto Detach option to automatically download all Outlook attachments and save to a certain folder easily.
Kutools for Outlook - With more than 20 handy Outlook add-ins, free to try with no limitation in 60 days
1. Click Kutools > Options. See screenshot:
2. In the Attachment Options dialog box, go to the General tab, and: (1) Check the Automatically detach all received attachments option; (2) Click the Browse button to specify the destination folder; (3) Check the Create subfolders in the followings style option, and specify a folder structure from below drop down list; (4) Click the Ok button. See screenshot:
From now on, all attachments of incoming emails will be automatically downloaded and saved into the specified destination folder.
20+ Powerful Tools and Features for Outlook 2010 / 2013 / 2016 / Office 365:
Compatible with Outlook 2010 / 2013 / 2016 / Office 365 (32/64);
Compatible with Windows XP, Windows Vista, Windows 7 / 8 / 10, Windows Server 2003/2008, Citrix System and Windows Terminal (Remote Desktop) Server;
Free trial without feature limitation in 45 days!
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 20 days agoIs there a way to modify the file name to include the date (ie: Filename.Date.filetype)
To post as a guest, your comment is unpublished.· 20 days agoHello!
I need that if the attachment is empty, that the macro left does not perform any action
To post as a guest, your comment is unpublished.· 26 days agoIn option 1, where am I supposed to hit ALT + F11? I tried with Outlook opened and it isn't working. Normal ALT + F11 does nothing, and ALT Gr + F11 opens my Intel HD Graphic Control Panel.
To post as a guest, your comment is unpublished.· 1 months agoHas anyone been able to figure out a way for this to work if the files you are saving all have the same name?
I get a bunch of files that I need to save daily, but there are at least 2 of each with the same name.
If anyone has any suggestions that would be greatly appreciated!!
- ← Previous
- Next →