Outlook 2013 VBA to save attachments


After much tinkling, got the VBA macro for saving attachments to work. There are many examples on the internet. All of them miss some key points:

– Embedded objects can’t be saved (and must be specifically skipped/ignored)

– Macro must be signed. If that also does not work, macro security must be lowered. (Options>Trust Center>Macro Security)

Some troubleshooting and reference links:

http://stackoverflow.com/questions/17706422/why-is-outlook-unable-to-save-a-particular-type-of-attachments
http://www.howto-outlook.com/howto/selfcert.htm

If you would like to create a button: http://www.howto-outlook.com/howto/macrobutton.htm

VBA References

If Else
http://www.databison.com/vba-if-function-using-if-else-elseif-if-then-in-vba-code/

Error Handling
http://www.cpearson.com/excel/errorhandling.htm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s