OutlookVBA

Collection of VBA scripts for Outlook to automate tasks.

DownloadAttachments.vba

This script is heavily based off of the one located here (https://www.extendoffice.com/documents/outlook/1166-outlook-save-all-attachments.html#VBA), except I cleaned it up, provided some optimizations, and solved the issue of downloading attachments from more than 250 emails.

Usage

1. Create a folder in your Documents folder called Attachments
2. Open VBA in Outlook using Alt + F11
3. Insert a new Module using Insert -> Module
4. Paste this file into code editor
5. Open Tools -> References, find "Microsoft Scripting Runtime" and make sure it's checked
6. Select emails you want to process in Outlook with your mouse
7. Press the ▶️ button in the toolbar or F5 on your keyboard
8. A message will appear saying "All Done!" when it is finished