How to Automatically Download/Save Attachments in Outlook to a Certain Folder Using [VBA + Rules]?

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
hello everyone i'm amit from mail smartly in this video you will learn how to automatically download and save attachment in outlook to a certain folder using vba and rules imagine you are working in a project and you receive tons of emails related to that project with attachments after returning from your vacation your email account is flooded with emails and it is very painful to download every email attachment in your hard drive in this video i will show you how you can easily customize your outlook with vba code and use rule function to execute your requirement so let's get started first of all there is no such direct rule which save all your email attachment in your computer you need vba code for that when you insert vba code you need to enable macros in outlook so first go to the file tab and from the list click on options [Music] your outlook options dialog box appears click trust center and here you see trust center setting click on it now you have to click on the macro settings and by default notification for digitally signed macros all other macros disabled is selected you have to change the selection and select notification for all macros and click ok and again okay now you have simply activated the macros any vba code you insert in your outlook will be automatically run without any other settings now it's time to inject your vba code into microsoft visual basic available in outlook so first of all go to developer tab click on it here is a visual basic click on it some of you don't have that developer tab so you simply use your alt f11 key to open the microsoft visual basics now here you have to click on the insert tab and from the drop down list select module that will open a blank script page now you have to insert the vba code in this page i already copied my vba code i have also added that vba code in the description below in this video so you can directly copy and paste from there so i show you how it works simply click ctrl v to paste before saving the code you have to make a slight change you have to replace the path i have already added my personal path so you have to replace this path with your part of the folder in which you like to save all your attachments now click save button and close this window now your macro is created in outlook now it's time to use rule feature to make your title into shape so click on the home tab [Music] and here you can see the rule function the rule key click on it and you have to select manage rules and alert from the drop down list click on new rules from the rules and alert dialog box now here comes the series of steps you have to select carefully to work properly so first click on the apply rule on messages i receive click on next now which condition do you want to check so if you want to fix a condition for those emails received from your boss you have to select the first option now click on here select the email address of your boss simply click ok the email address of your boss will be added if you want for the specific word added in the subject you can select this you can click here specific word enter the word you want to be in the subject which you want to target for this rule click on it click ok your word will be added but in my case i like all of them unchecked which means the rule runs for all the emails i received there is no such restriction i leave all of them unchecked which means the rule runs for all the emails i received in my inbox now click next now outlook shows you this rule will be will be applied to every messages you receive is this correct so i just simply click yes because i want to implement that rule to all the email messages receive in my inbox so i just click yes there is a go ahead permission from my site now next option is what do you want to do with the messages now you have to select any one of it when i draw scroll down my mouse there is an option run a script i select this now here i want to tell you something 99 of the users doesn't have this option run a script in their rule because this run a script feature is disabled by microsoft outlook update because of their security reasons i am i have this run a script option because i have added this feature manually in my outlook you will go to my description section here you will get a url of my website where you can go and download that specific script and upload in your outlook that will easily add this run a script option in your outlook now restart your outlook and you will see this run a skip script option available in your rule wizard so select this and here run a script in the step two section appears click on it and when you click on it select script dialog box appears one of the script which i have added in the earlier part of this video is already shown here which is already selected you simply click the change name changes automatically to the the name of the script now click on the next button now there is an another option of are there any exemptions i usually leave this section as it is if you want to exempt anything from your rule you can select any of any of this option and simply click next this is the finished rule setup you can name your rule so i just name it [Music] auto save attachment and select this check box of run this rule now on messages already in inbox because i want all the messages having attachment to be saved in the specific folder i have already mentioned in the code now this is already selected and simply hit finish when i click finish the rule takes some time and all the attachment in this room in this inbox will be automatically saved in your specific folder i hope you found these videos useful also if you like this video please subscribe to this youtube channel and click on the bell icon so you will never miss out any outlook tips and problem solvers videos i come up with thank you and have a nice day [Music]
Info
Channel: Mail Smartly
Views: 36,153
Rating: undefined out of 5
Keywords:
Id: NHBb39qdlSs
Channel Id: undefined
Length: 7min 46sec (466 seconds)
Published: Sat Aug 27 2022
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.