facebook twitter youtube
in How & Why - 28 Jul, 2010
by Amit Gupta - no comments
Outlook macro

This is a very good example of visual basic macro. If you use outlook in your office or at home this code will surely save your time. This code is suggested by my friend Prathamesh Raorane.

This code is tested on Outlook 2003 and 2007 version

When you click on reply to all button in outlook, automatically list of attachments are removed. But list of all people which were in CC or in TO files are shown. Similarly, If you forward a mail then list of ids under CC or TO fields are removed. But attachment retained. Prathamesh gave me a code that can do both work in one short.

This area is protected to registered users only.

To use above code.

Open Outlook [I tested the above code in Outlook 2003 & 2007]
Press Alt + F11. Otherwise go to Tools menu and select macro option.
Open the macro editor.
Copy paste above code. And save it.
You may add a toolbar button. So from the next time you can run the code directly from the toolbar. Otherwise you’ll have to go to Tools > macro every time.

Once everything done then every time when you run the code will open separate window similarly when you click on “reply to all” button. List of attachments will be retained this time.

Special Thanks to Prathamesh Raorane

Amit Gupta

Hey! this is Amit Gupta (amty). By profession, I am a Software Eng. And teaching is my passion. Sometimes I am a teacher, as you can see many technical tutorials on my site, sometimes I am a poet, And sometime just a friend of friends...

Leave a Reply