How to select a Tab on Outlook 2010 Ribbon using VBA?

[parodytx]

Newbie Outlook 2010 VBA programmer, intermediate Excel 2010 VBA Programmer.

I have programmed a rule calling a VBA macro that automatically forwards all email received to an offsite account. Sometimes the rule fails with an Outlook (not VBA) error message and the rule becomes inactive until I reactivate it (by selecting the rule, clicking through all the choices and finally hitting Apply) then all is fine again (until the next time it happens.) Best guess as to its malfunction has to do with certain external emails received.

I would like to have a macro that runs at Outlook Start-up that does one thing - clicks the Rules Tab on the Home Ribbon, then selects Manage Rules & Alerts drop-down menu item, which would then open the Rules and Alerts page so that I could ensure that the rule is activated and working.

Is this possible? I am not as familiar with the Object Model for Outlook as Excel and do not know even where to start.

Thanks for your help.

[skatonni]

I do not think your goal can be accomplished the way you state.

You will want https://msdn.microsoft.com/en-us/lib...ffice.14).aspx to run this code at startup.

Private Sub Enable_Rule()
   
    Dim olRules As Rules
    Dim olRule As Rule
    Dim rulename As String
    
    rulename = "Name of rule here"
    
    Set olRules = Application.Session.DefaultStore.GetRules
    Set olRule = olRules.Item(rulename)
    
    olRule.Enabled = True
    olRules.Save
    
    Set olRules = Nothing
    Set olRule = Nothing
    
    MsgBox rulename & " - should be enabled."
    
End Sub