Windows Explored

Everyday Windows Desktop Support, Advanced Troubleshooting & Other OS Tidbits

Archive for August 3rd, 2010

User Request – Count Outlook Attachments in Outlook

Posted by William Diaz on August 3, 2010

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:

Sub CountAttachmentsMulti()

Set mySelect = Outlook.ActiveExplorer.Selection
For Each Item In mySelect
j = Item.Attachments.Count + j
I = I + 1
Next Item
MsgBox “Selected ” & I & ” messages with ” & j & ” attachements”

End Sub

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:


Posted in Office | Tagged: | Leave a Comment »

Using Application Logs to Troubleshoot a Failed Web Meeting

Posted by William Diaz on August 3, 2010

Here is an example of using application logs for troubleshooting. In the case here, the user was unable to connect to a video meeting hosted across the web in an application called iLinc. After logging into the initial login page, the user was presented with the following prompt requesting further authentication:

Posted in Troubleshooting | Tagged: | Leave a Comment »