Ok - a complicated one - but really need help (auto formatting)

Status
Not open for further replies.

blazingcrayon

Member
Outlook version
Email Account
Exchange Server
Ok - I'll try and be clear. I'm not a tech guy so be forgiving.

I work out of a shared inbox. Multiple groups work in this inbox and we have created views for each group.

lets look at View 1. View 1 has two teams working out of it, and the members of each team have a category assigned to them (teamA) and (teamB)

We want items not owned by one team OR the other to be highlighted in BLUE.

There are three categories this rule will apply to (cat1) (cat2) and (cat3)

if an email has one of those category tags on it (it is assigned tags based on VB script and macro), we want it blue if no one owns it. If someone takes the email in hand they assign themself to it - so my tage would read "blazingcrayon (teamA)"

If I set the autoformatting with just "categories doesn't contain (teamA)" it works. when I add "doesnt contain (teamB) it treats it as an AND.

Querybuilder seems to fix it, but is stored on local registry so it doesn't work across the shared inbox on multiple users machines. We dont like the relaibility of querybuilder so dont want to add it to everyone's outlook.

any thoughts on how I can get the autoformatting to not be blue with EITHER (teamA) OR (teamB) tagged to it?
 
Double negatives are hard to work with. The 'doesn't contain' and the OR ends up looking at both making a mess of things. if not team1 or if not team2 includes both because the first is true if team2 is assigned and the second is true if team1 is assigned.

Assuming the team categories will have a common word not used in cat1, cat2, or cat3, try 'category does not contain team' where team is the unique word.
 
Double negatives are hard to work with. The 'doesn't contain' and the OR ends up looking at both making a mess of things. if not team1 or if not team2 includes both because the first is true if team2 is assigned and the second is true if team1 is assigned.

Assuming the team categories will have a common word not used in cat1, cat2, or cat3, try 'category does not contain team' where team is the unique word.

hmm - the teams don't have a common name... it's actually like (ABC) and (DEF)

any thoughts?

I got it to work in one particular view, where it is set with Categories = #Cat4 then on advanced has doesnt contain Brian, doesnt contain Laura, doesnt contain John... etc... this view works... the email, if tagged as #Cat4 stays blue until any one of these tags it with their name...

but for other views there are multiple categories and multiple "doesnt contain"s

sorry I know this is complicated - but I'm almost positive there's a way to make it work!
 
Renaming the teams is out of the question? :) Filtering would be easier - hide everything with team 1 or team2, so only items with no team assigned is visible.

Or color everything blue then color items assigned to teams in black. This gets rid of the double negatives. :)
 
Renaming the teams is out of the question? :) Filtering would be easier - hide everything with team 1 or team2, so only items with no team assigned is visible.

Or color everything blue then color items assigned to teams in black. This gets rid of the double negatives. :)

Im actually tryin your suggestion - so it is not blue if category = Cat4, then on advanced tab

category contains (abc)

category contains (def)

seems to be treating it as AND instead of OR... anyway to fix this?
 
ok, I think I've determined more -

when dealing with categories ... does outlook treat a whole category (exact match) different that a doesnt contain?

because in one of my views this works:

Categories #Team1

now we go to advanced tab and put in 3 "doesn't contains" each to a team members' exact category

so like this: Doesnt Contain :Brian (Team1)

Doesn't contain :John (Team1)

Doesn't contain :Laura (Team1)

so it was working as "if it doesnt contain brian OR John OR Laura, then be BLUE

I learned to lean this out I could just use

Doesnt Contain (Team1) and it works!! Anythign with #Team1 Category but not (Team1) anywhere in the categories stayed blue, and if any of us tagged ourself to it, its black

but...

when two teams in a different view can each take complete ownership, there are 10 total members and I don't want to do a "doesnt contain" for each of their names, but rather just use that shortcut feature and still have it treated as OR

so say Team1 or Team2 can take ownership of an email with category #Team2

I dont want to do the

doesnt contain :Laura (Team1)

doesnt contain :Brian (Team1)

doesnt contain :Nolan (Team 2)

Doesnt contain :Martha (Team2)

I want to do it like

doesn't contain (Team1)

Doesnt contain (Team2)

this goes back to the original query, except now I'm pointing out a situation with exact category matches the OR functionality does work even with the negative!

so longwinded way of asking, doesn outlook treat an exact match in category different than looking for a piece of a category
 
Yes, Outlook treats contain and doesn't contain as a wildcard of sorts - if the category contains (or doesn't) the word, it matches it. That is why I suggested changing the team names (like prefacing both with a unique character) - a single 'doesn't contain' will apply to both teams.

Exact match is an exact match.
 
Yes, Outlook treats contain and doesn't contain as a wildcard of sorts - if the category contains (or doesn't) the word, it matches it. That is why I suggested changing the team names (like prefacing both with a unique character) - a single 'doesn't contain' will apply to both teams.

Exact match is an exact match.

thanks - I just can't figure out why exact matches are treated like "OR"s and the partial part of a category is treated like "AND"

basically, its like this in one view

IF Category is #TEAM1, TURN BLUE IF

categories doesnt contain Brian (Team1) or categories Doesnt contain Laura (Team2)

in the even either of us tag the email, it is no longer blue.

but if I do doesnt contain (team1)

doesn't contain (team2) it treats it like AND

sorry to be beating this to death, but it's kind of how I really need to operate! :)
 
You are asking the filter to do something if either of the conditions are true:

if not in Team1

OR

not in Team2

since everything is in either Team1 or Team2, the condition is TRUE.

You need to use if not in Team1 AND not in Team2 - but when you use the same field twice, it is always OR'd. You need to use AND when you are using not.

Categories add a special twist since they are a text field. Normally, you can use two or more values in the Value field - mary OR joe - or mary, joe - but because categories is a text field, if you use OR, it thinks you are looking for the phrase 'A OR B', not A or B.

Believe it or not, I spent an hour tonight trying to figure out why 'widget logic' would not work on my wordpress site. I wanted to do 'if not in A or if not in B' and even after working on this with you today, I still screwed up my logic. Have I said how much I hate negatives? ;) I needed to use 'if not in A AND if not in B' - if the phrase could be "if not (A or B)" it would work, but it works like outlook's doesn't contain and is written as "(if not A) OR (if not B)"
 
You are asking the filter to do something if either of the conditions are true:

if not in Team1

OR

not in Team2

since everything is in either Team1 or Team2, the condition is TRUE.

You need to use if not in Team1 AND not in Team2 - but when you use the same field twice, it is always OR'd. You need to use AND when you are using not.

Categories add a special twist since they are a text field. Normally, you can use two or more values in the Value field - mary OR joe - or mary, joe - but because categories is a text field, if you use OR, it thinks you are looking for the phrase 'A OR B', not A or B.

Believe it or not, I spent an hour tonight trying to figure out why 'widget logic' would not work on my wordpress site. I wanted to do 'if not in A or if not in B' and even after working on this with you today, I still screwed up my logic. Have I said how much I hate negatives? ;) I needed to use 'if not in A AND if not in B' - if the phrase could be "if not (A or B)" it would work, but it works like outlook's doesn't contain and is written as "(if not A) OR (if not B)"

thanks Diane and forumadmin - you guys are a credit to the board!

I'll keep tinkering... too bad querybuilder wont work in a shared box!
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R [VBA] complicated(?) outlook events - need help with code Using Outlook 15
L Does this really work and get thru virus and malware blocks? Using Outlook 3
B How to 'really' delete IMAP emails? Using Outlook 6
R SEARCH PEOPLE - would like one that really works Using Outlook 1
B How do I REALLY disable Outlook Junk E-mail sorting in OL2010 and/or 2013? Using Outlook 1
L Recover Deleted Items Folder shows email which are not really deleted. Using Outlook 0
Horsepower Now I'm REALLY upset Using Outlook 6
H Outlook Does Not Really Close When I Close It BCM (Business Contact Manager) 1
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 10
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
P OT: Need website like this one, but for Excel Using Outlook 0
S Need code to allow defined starting folder and selection from there to drill down Outlook VBA and Custom Forms 10
D Need help with MS Authenticator Using Outlook 4
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S.Champ Please help? I've imported a random workcalendar I dont even know who's. Can I undo it? and then I need to re-sync the google one again. Its a mess:( Using Outlook 2
B Need to Copy an email to a subfolder Outlook VBA and Custom Forms 2
D Do I need Exchange Add-In? Using Outlook 6
L Need help modifying a VBA script for emails stuck in Outbox Outlook VBA and Custom Forms 6
K Need to convert .mmf file to .pst format Outlook VBA and Custom Forms 7
glnz Moving from Outlook 2003 to MS365 Outlook - need basics Using Outlook 4
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 14
A Wishlist Arthur workman I need the community's assistance thank you Using Outlook 3
A from Arthur to anyone I need your expertise assistance Using Outlook.com accounts in Outlook 7
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
T Need to backup outlook.com to cloud storage, without desktop software - Testing UpSafe. Are there any similar services? Using Outlook.com accounts in Outlook 8
C need help setting up outlook first time Using Outlook 1
N Need help syncing contacts to iPhone X Using Outlook 8
L Need to import multiple Outlook files to Office 365 Account Using Outlook 4
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
E Outlook 2010 need help with rules Using Outlook 0
Horsepower Need iCloud mail only Using Outlook 1
O Don't need any add-ins at all? Using Outlook 2
B Need Help - Willing to pay Outlook VBA and Custom Forms 10
A Need to view Outlook calendar in Sharepoint .. Using Outlook 2
J Need Help with Contacts VBA Outlook VBA and Custom Forms 1
L Accidentally merged a calendar with .ics, need to undo! Using Outlook 1
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
D Need Genuine Office or Outlook 2007 Using Outlook 3
G how to cancel a recurring meeting but not the organizer but all attendees need to know. Using Outlook 1
H I need a developer to customize an Outlook Contact form Outlook VBA and Custom Forms 0
T Need help with finding/updating task Outlook VBA and Custom Forms 1
N Need a case sensitive rule Outlook VBA and Custom Forms 1
C Need rule to alert when an email has not been replied to within 24 hours Using Outlook 1
P Outlook 2003 - Do I need a new profile? Using Outlook 2
F Outbox - Multiple Emails need to be manually opened? Using Outlook 5
Miquela I need to make a calendar to share here at work with 40 other people Using Outlook 1
S Need CC: to show the original To: recip[ients Using Outlook 4

Similar threads

Back
Top