- HOW TO MAKEO OUTLOOK CONDITIONAL FORMATTING FOR ALL FOLDERS SOFTWARE
- HOW TO MAKEO OUTLOOK CONDITIONAL FORMATTING FOR ALL FOLDERS CODE
It appears that the numbers are being ignored and Outlook sees these two criteria as equivalent. What actually happens is, only the first of these two rules is applied to the email. For example one message would have a subject containing the string "1 Successful, 0 Failed" and be oneĬolor while another would contain "0 Successful, 1 Failed". The only difference between the two rules is a variation in a couple of numbers. I have two rules that look a specific text in the subject of emails. I use color coding extensively and since upgrading from Office 2007 to 2010 I've noticed a couple of my color rules no longer For more information visit been using Outlook 2010 for a few weeks now and I've discovered what I think may be a bug in Outlook's Conditional Formatting.
HOW TO MAKEO OUTLOOK CONDITIONAL FORMATTING FOR ALL FOLDERS SOFTWARE
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. But if it fails, you can proceed to resort to an external tool, like DataNumen Outlook Repair. Therefore, what should you do in the event of crash? Generally, you can try the inbox repair tool to fix PST issues in the first place. At worst, it can crash without any warnings. Finally, you will see that all the custom conditional formatting rules have been disabled.Īlthough Outlook boasts of myriad features, it is still error prone. Now, you can check “View Settings” > “Conditional Formatting” in each folder. When the macro completes, you’ll get a prompt suggesting “Completed”.After you selecting one file and click “OK”, the macro will start to disable all of the custom formatting rules.Later, you’ll be required to select a source Outlook data file under which you want to disable all the conditional formatting rules.After that, you can trigger this macro by hitting the “Run” icon the toolbar or simply hitting F5 key button.If > 0 Thenįor Each objSubfolder In objCurrentFolder.Folders 'Disable all conditional formatting rulesįor Each objRule In objView.AutoFormatRules
Set objView = objCurrentFolder.CurrentView If objCurrentFolder.DefaultItemType = olMailItem Then Sub ProcessFolder(ByVal objCurrentFolder As Outlook.Folder)
Set objOutlookFile = įor Each objFolder In objOutlookFile.Folders Sub DisableAllCustomConditionalFormattingRules()
HOW TO MAKEO OUTLOOK CONDITIONAL FORMATTING FOR ALL FOLDERS CODE
Subsequently, copy and paste the following VBA code into this module.In it, you should open a module which is not in use. Next, the “Microsoft Visual Basic for Applications” window will display.Then, in the Outlook main window, you should press “Alt + F11” key buttons.At the very outset, launch your Outlook application.In this case, you had better utilize the following way, which can help you achieve it in bulk.īatch Disable All Custom Conditional Formatting Rules But if afterwards, for some reasons, like resetting the view, you may hope to disable all these custom conditional formatting rules. If one day you desire to batch disable all of such custom rules, you can use the method introduced in this article.Ĭonditional formatting feature allows users to use different fonts and colors to highlight the emails based on their custom criteria. In Outlook, you can create various custom conditional formatting rules to change the display font and color of the items.