background preloader


Facebook Twitter

OutlookSpy - the Ultimate Outlook Developer Tool. Enumerate all CommandBars. Sub EnumCommandBars() Dim objOL As Outlook.Application Dim objNS As Outlook.NameSpace Dim objDrafts As Outlook.MAPIFolder Dim objPost As Outlook.PostItem Dim colCB As Office.CommandBars Dim objCB As Office.CommandBar Dim strWindow As String Dim strExplBars As String Dim strInspBars As String Dim strText As String Dim arrBars() As String Dim i As Integer On Error Resume Next Set objOL = Application Set objNS = objOL.Session Set objDrafts = objNS.GetDefaultFolder(olFolderDrafts) strExplBars = "Menu Bar,Standard,Advanced,Web" strInspBars = "Menu Bar,Standard,Form Design,Formatting" strWindow = TypeName(objOL.ActiveWindow) Select Case strWindow Case "Explorer" Set colCB = objOL.ActiveExplorer.CommandBars arrBars = Split(strExplBars, ",") Case "Inspector" Set colCB = objOL.ActiveInspector.CommandBars arrBars = Split(strInspBars, ",") End Select If Not colCB Is Nothing Then Set objPost = objDrafts.Items.Add("IPM.Post") objPost.Subject = "CommandBars for " & strWindow & _ ": " & colCB.Parent.Caption Next objPost.Save End If.

Enumerate all CommandBars

Batch Print PDF Attachments in Outlook. This article was written by Sean Tsai, a data warehousing expert and good friend of the How-To Geek Have you ever wanted to print every attachment you receive in your Outlook email box?

Batch Print PDF Attachments in Outlook

Let’s say you subscribed to a free fax to PDF email service and you want them to be printed out automatically just like an old fashioned fax machine. Here is a quick way to achieve that if you are comfortable with a little bit of VB (macro) programming. What we showing here is to create a rule in Outlook and move the incoming fax emails into a separate subfolder. Using VB code we create a macro for you to run a print job against every email in that subfolder so you don’t have to open up the email and print the attachments one by one. Step 1 Create a subfolder named “Batch Prints? Step 2 Create a rule (from menu Tools/Rules and Alerts) in Outlook that looks like this: Place the email address from your fax vendor in the field “

Step 3 Create a VB macro. Step 4 Step 5 Step 6 Using the Macro. Using Command lines. When you're having problems with Outlook you may be told to start Outlook using a specific command line switch.

Using Command lines

To do this: Close Outlook. At the Start menu, Run command (or open the Run command by pressing Windows Key ( ) + R type: