- #Outlook conditional formatting not working how to
- #Outlook conditional formatting not working update
- #Outlook conditional formatting not working software
#Outlook conditional formatting not working software
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including recover mdf and outlook repair software products. Hence, you should keep cautious all the time in data protection, such as persisting in regular PST backup and preparing a potent fix tool, like DataNumen Outlook Repair, which can fix Outlook issues in a jiffy. For instance, if you accidentally click on a malicious link in unknown emails, your Outlook file may be virus infected and even become damaged. Most of time, a tiny mistake can result in data loss with ease. In reality, such ideas are totally wrong and risky. Myriad users still hold the thoughts that data corruption will never occur to them. After you return to Inbox, all the important emails which you haven’t replied have been highlighted in the specific font and color.ĭon’t Be Slack in Outlook Data Protection.
![outlook conditional formatting not working outlook conditional formatting not working](https://mailsmartly.com/wp-content/uploads/2020/09/Auto-highlight-emails-based-on-age-in-Outlook.png)
Ultimately, click a series of “OK” to save this formatting rule.Subsequently, in the “Filter” screen, on “Advanced” tab, add two filters.After specifying font, hit “Condition…” in “Conditional Formatting” dialog box.Later, click “Font…” button and set the font style and color in the popup “Font” dialog box.In the next “Conditional Formatting” dialog box, click “Add” and enter a name for the new rule, such as “Not-replied Important Emails”.In the new dialog box, click “Conditional Formatting” button.Then, turn to “View” tab and click “View Settings”.Subsequently, follow the steps below to create a conditional formatting rule for items in Inbox.After that, move cursor into the “Application_Startup” macro and hit “F5”.If (Not (strRepliedStatus = 102)) And (Not (strRepliedStatus = 103)) Then Set objRepliedProperty = ("Replied", olText, True) Set objRepliedProperty = ("Replied", True) If objFolder.Items(i).Class = olMail Then 'Write the replied status to a new user property of emailsįor i = To 1 Step -1 Private Sub UpdateRepliedStatus(ByVal objFolder As Outlook.Folder)ĭim objRepliedProperty As Outlook.UserProperty Private Sub objSentMails_ItemAdd(ByVal Item As Object)
#Outlook conditional formatting not working update
'After sending an email, auto update the replied status of the emails in Inbox 'On startup, auto update the replied status of the emails in Inbox Private WithEvents objSentMails As Outlook.Items Private WithEvents objSentFolder As Outlook.Folder Then, in the new window, copy the code below into the “ThisOutlookSession” project.At the very beginning, access VBA editor via “Alt + F11” in Outlook.Auto Highlight the Important Emails You Haven’t Replied
#Outlook conditional formatting not working how to
Provided that you’re unfamiliar with VBA, please refer to my previous article – “ How to Run VBA Code in Your Outlook” meanwhile. Now, in the followings, we’ll guide you to achieve it with VBA.
![outlook conditional formatting not working outlook conditional formatting not working](https://i.ytimg.com/vi/G-9Um7GvNCY/maxresdefault.jpg)
![outlook conditional formatting not working outlook conditional formatting not working](https://cdn.extendoffice.com/images/stories/doc-excel/change-color-if-not-equal/doc-change-cell-if-not-equal-2.png)
Have you ever missed any important emails and not replied them in time? If you have been suffered such issues, maybe you will hope that Outlook can highlight the important emails that you haven’t replied. Now, this article will teach you how to get it. So as to remember to reply the important emails, you may wish Outlook to show the vital emails you haven’t replied in a specific manifest color to highlight them.