Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2022, 05:58 PM
XtremeMaC XtremeMaC is offline Apply Rule with a unique exception Windows 11 Apply Rule with a unique exception Office 2016
Novice
Apply Rule with a unique exception
 
Join Date: Aug 2022
Posts: 1
XtremeMaC is on a distinguished road
Default Apply Rule with a unique exception


Hi,
I've 2 rules, one that looks at keywords in senders domain and the other in recipients domains. Then applies a Category, basically to weed out the people outside my domain.
Then, I use Conditional Formatting to change color of email read/unread if it's from External's category.

Now there's one person that's outside my domain, however he's our resident engineer. So, I want to exclude him from triggering the rule, or basically omitting him..
If I set a rule with exception, "except if" then all emails he's in are ignored regardless of other External domains in the email. As in, Category not applied to all..

How to come up with a rule or vba that will omit applying the rule if he's the ONLY external domain? If there are other participants under the same external domain or other external domains, then the rule shall apply.

Yes, I can write it myself for sure. Looking for the easy way out here, if someone already has something like this.

To give an example:
My domain: microsoft.com
Outside domains: google.com, yahoo.com, etc.
My resident engineer email: resident@microsoft.com and resident@google.com. email could be from either or he can be in the CC or in the TO.
Filter looks for: google.com, yahoo.com in the recipient and senders email and applies External category.

This is for work laptop. Win10 x64, MS365 Office 2016... I've scripts enabled in Outlook and already run few macros.

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Able to set up delegate meeting folders rule but cannot create an effective rule for my own meetings kottman Outlook 0 03-08-2019 12:48 PM
Outlook rules - exception to exception?? Dr. Demento Outlook 0 02-14-2017 06:49 AM
Rule to apply to all domains jaarons Outlook 1 05-25-2015 02:41 PM
Apply Rule with a unique exception Apply same bullet rule to whole document geezawolf Word 4 10-23-2012 01:45 AM
Database exception: login failed rkoziol7 Outlook 0 05-23-2011 01:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft