This script facilitates the quick saving of Outlook attachments in a batch, rather than individually, through a macro.
- Modify Line 90 to specify the folder location where you want to save all attachments:
strFolderPath = "C:\Users\nopantscarl\Desktop\Needs work"
- Navigate to "File" in Outlook and select "Options."
- Choose "Outlook Options," then "Customize Ribbon."
- On the right side, locate and enable the "Developer" tab.
- Return to the main Outlook window to access the developer ribbon.
- Click on the "Macro Security" button.
- In the subsequent window, select "Notifications for all macros" and confirm.
- Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
- Click on "Insert" > "Module" and paste the provided code into the module, or import it at this stage.
- Press F5 to display the modules and click "Run" to execute the macro.
- Follow the aforementioned steps to access Outlook options.
- Choose the "Quick Access Toolbar" tab.
- Select "Macros" from the "Choose commands from" dropdown menu.
- From the macro list, select the desired macro (either the name you assigned or the imported name).
- Click the "Add >>" button at the center.
- Click "OK" to confirm.
- To execute the macro from the Quick Access Toolbar, simply click its corresponding button.