Welcome to Office Zealot Sign in | Join | Help

New Outlook programming article on MSDN

NOTE:
Due to data loss with OfficeZealot's blog server, all comments posted between April 28 and June 8 , 2005 to any of my blog entries were inadvertently deleted.  The end of this blog entry contains the text of the comments applicable to this posting that I was able to recover.

Update:
The source code for the MSDN article can be downloaded here.  It includes the complete form as well as the code modules.

Have you ever received an e-mail with a lot of attached picture files in Outlook?  To say the least, it is somewhat painful to double-click the little attachment icons in the message header one-by-one to view each picture.

With a little Outlook macro magic, you can easily build a nice little helper form with VBA and the Outlook Object Model to make this process far more manageable.  Full instructions are in this article on MSDN:

Office Developer Center: Viewing Multiple Picture Attachments in Outlook 2003:
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_ol2003_ta/html/Office_Outlook_ViewMultPictAttach.asp

----------------------------------------------------------------
 COMMENTS RESTORED FROM BACKUP:

Wed 4/27/2005 2:33 AM Paule

I am a extreme newbie to VBA. BUT I was tired of not being able to open multiple pictures in Outlook 2003 as I did in a prior version. When I googled to the MSDN site I was pleased to try to get the macro/script to work. I had no success. Again I Googled and found this Blog. WOW what a great site and help. It all works now plus I learned more about security digital signatures. Now my downloaded Acess templates from Microsoft work using this information. Thanks!!! ;-)

Wed 4/27/2005 10:12 PM ClearYourSix

Even better, how would I go about simplifying the procedure so that upon click of the button, it automatically opens all files in the default viewer without pulling up the userform?

Thu 4/28/2005 3:32 PM Eric Legault http://blogs.officezealot.com/legault

ClearYourSix: That wouldn't be too hard to do. Most of the code to save the attachment files and send it to a viewer is already there, you just have to move it around so that it works without the form and when called from a custom command bar button or a macro.

END COMMENTS RESTORE
 ----------------------------------------------------------------

Published Wednesday, January 12, 2005 2:10 PM by legault
Filed under: ,

Comments

Anonymous comments are disabled