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
