How to Quickly Find All Outlook Rules Whose Names Contain a Specific Keyword

Outlook doesn’t provide the inbuilt function to search rules. Therefore, if you would like to search the Outlook rules whose names contain a specific keyword, normally, you have to check all rules one by one. But this post will show you a much smarter method.

You can create various rules in your Outlook at will. The rules are able to make your work with incoming and outgoing emails automated and efficient. However, if there are too many rules in Outlook, you will feel it a bit difficult to manage and control them. For instance, if you wish to do something with the rules containing a certain keyword in the name, generally, you have to find them among all the rules manually. That would be a pretty arduous task. But don’t worry. Here we’ll share a more intelligent approach to you. It can let you find the specific rules in a jiffy.

Find All Outlook Rules Whose Names Contain Specific Keyword

  1. First, launch Outlook application.
  2. Next, access to the VBA editor with accordance to “How to Run VBA Code in Your Outlook“.
  3. Then, in the “Microsoft Visual Basic for Applications” window, copy the code below into a new module.
Sub FindAllRulesContainingSpecificKeywordInName()
    Dim objStores As Outlook.Stores
    Dim objStore As Outlook.Store
    Dim objRules As Outlook.Rules
    Dim i As Long
    Dim objRule As Outlook.Rule

    Set objStores = Outlook.Application.Session.Stores

    'Process all mailboxes
    For Each objStore In objStores
        Set objRules = objStore.GetRules

        For i = objRules.Count To 1 Step -1
            Set objRule = objRules.Item(i)
            'Find specific keyword in rule name
            If InStr(objRule.Name, "Shelly") = 0 Then
               objRule.Enabled = False
               objRule.Enabled = True
            End If
        Next i
 End Sub

VBA Code - Find All Outlook Rules Containing Specific Keyword

  1. After that, click the “Run” icon in toolbar to run this macro.
  2. When macro finishes, follow the steps below to check the filtered rules.
  • First off, go to “File” menu.
  • Then, click the “Manage Rules & Alerts” button on “Info” tab.Manage Rules & Alerts
  • Next, in the popup “Rules and Alerts” window, you can see that the rules containing the specific keyword in name are enabled and checked. But the other rules which don’t contain the keyword are disabled, as shown in the following screenshot.Specific Rules That Contain Specific Keyword

Troubleshoot Outlook Problems

It’s common to encounter a variety of Outlook issues if you have used Outlook for decades. They can be some tiny problems, like occasional small errors, or some serious troubles such as severely corrupt PST file. Generally, when encountering such Outlook problems, you can first restart it, then disable third party add-ins or rebuild mail profiles and finally resort to a professional and robust fix utility, like DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql corruption and outlook repair software products. For more information visit

7 responses to “How to Quickly Find All Outlook Rules Whose Names Contain a Specific Keyword”

  1. this module wiped out all my rules! any thoughts on how I can restore them? (no, I don’t have a backup, my fault)

  2. I got an error that said your store does not support, Bla, bla Bla. But your code worked perfectly and put a check mark on the one rule I needed to see. I have about 5000 rules so this was badass!!!! TYVM.

  3. Microsoft Visual Basic for Applications Error – This store does not support rules. Could not complete the operation.

    Microsoft Outlook 2019

  4. My god!!! Are you kidding me? Your damn module wiped my entire rules file out! You’re an irresponsible moron!!!

  5. Great solution! Any way to narrow down the search. All mailboxes takes forever for the module to run. Looks like its searching the entire DB vs the rules file.

Leave a Reply

Your email address will not be published. Required fields are marked *