If you have a lot of messages with attachments and you need to save the attachments to your hard drive, it can take a lot of time to go to File, Save Attachments, Save all for each message. While there are several commercial add-ins that can automate the process, you can use VBA to make the process a bit faster.
Since anti-spam filters don’t care much for VBA code, I won’t put the code in this email. Instead, the code and instructions at Save and Open an Attachment using VBA
A list of utilities that do this (and more) are available at
Attachment Management Tools for Outlook
Many of these utilities offer additional features that make them cost effective for anyone who needs to save attachments often.
Published December 12, 2008. Last reviewed on May 8, 2014.