haserbroad.blogg.se

You're unlikely to see that error message in Outlook 2010 since Outlook 2010 doesn't have an Organize pane. Type in the email address of the sender or senders you want to highlight. If you need more formatting rules, options include combining the rules that use the same color or use some other method to keep the number of rules lower. Pick a color, style and size and click ‘OK’. There is a limit of 27 automatic formatting rules allowed per view. I'm getting the message: "You can not add another color rule because you have extended the maximum number of rules in this folder. In Tools/Organize, you can choose a color to display a message from a specific sender when messages are received in Inbox. The question usually goes something like this: The email will turn green.Every now and again, we get asked if there is there a limit to the number of Automatic formatting rules. Now when ever the issue from the failure email is resolved, just right-click on the email, go to Follow Up, select Mark Complete. This is important otherwise the red rule will override the effects of the green rule. In the More Choices tab, check the Only Items which: and select the drop-down value of are marked complete.īack in the Conditional Formatting window, move the green job up. In the filter window, follow the same steps as in the previous red rule. Now we want another rule that will change the red email to a green one when it is marked as complete. Add another Conditional Formatting rule, rename it and change the font color to green and click on Condition. Click on OK to come back to your inbox and verify that the error emails have a red font.Ĭreate a Conditional Formatting Rule to Highlight a Failed Job Email in Green After Resolution:

If you get emails with different text patterns then you can always create a new rule for each phrase. Now this a simple example with a text phrase for filtering but you can use other criteria in More Choices and Advanced tabs too for more complex scenarios as necessary. My emails have the following text in the email body that I can use for identification – just in the email subject or, email body or both. Also specify in the drop-down where exactly the filter should look for the text phrase i.e. In the Filter window, put a sufficiently unique text phrase from the error email that can distinguish it from good emails. In the Conditional Formatting window, click on Add and rename the new untitled rule. Then change the font color to red and click on Condition. Right-click on the header row and go to View Settings. You can even customize your main Inbox folder view, if that is where your emails are. Navigate to the folder where you would like to modify the view. The conditional formatting rules highlight the job failure emails with the red color and turn them green when marked complete as shown in the following image.Ĭreate a Conditional Formatting Rule to Highlight a Failed Job Email in Red: In addition to that, I use conditional formatting rules to keep track of action items as pending or done. I use filter rules in MS Outlook to organize my inbox by redirecting all the scheduled job emails to a separate folder. Some scheduled jobs send failure emails upon an error and DBAs need to remember to fix the job and re-execute it.