Windows Explored

Here is an odd user request presented to one of our techs. The user wanted to be able to count the number of attachments in an email, especially those with many attachments. You can do all kinds of stuff using Visual Basic in MS Office and a quick Internet search revealed some simple VB code that would create macro in Outlook to count attachments

To do this, open the Visual Basic Editor from Tools > Macro > Visual Basic Editor. Right-click the Modules folder and insert a new module and copy and paste the following text into the editor window:

Add the macro to the Outlook standard toolbar or create a new one. Do the same for open messages. Now you can select a message, a range of messages, or open a message and run the macro and get a neat dialog box: