[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

MS Outlook Rules search text logic

Posted on 2016-07-21
13
Medium Priority
?
94 Views
Last Modified: 2016-07-28
Hello,
I'm trying to set an Outlook rule whereby it will search the body of the email for two fields.
Example; QA Revieer and (a person's name).  I automatically get the "or" but I need an "and" in the logic of the search;
Need an "and"
0
Comment
Question by:chima
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 

Author Comment

by:chima
ID: 41723385
I should say that a phare like; "QA Reviewer: Joe Smith" does not work, because, I believe the text comes in a table format.
So I need to first search on QA Reviewer then "and" search for the name of the person assigned.
0
 
LVL 9

Expert Comment

by:dipersp
ID: 41723654
Outlook has a query builder, but I don't believe that works in rules.  It does for find and search folders though.  Might be a help?  Not sure what you're trying to do.  (http://www.slipstick.com/outlook/using-query-builder/)

Only other thing I can think of (Sloppy) is two rules.  First rule looks for one of the words.  If it's found, flag the message or set a category.  Second rule looks for the second word and the category/flag from the first rule.
0
 

Author Comment

by:chima
ID: 41723660
dipersp, thank you for the response.  I'm trying to sort incoming emails by two fields on the same email; "QA Reviewer and Joe Smith"
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:dipersp
ID: 41723662
Sorry, you're going to have to give me a little more.  You've lost me since you started out with rules and looking for text/fields in the email and now you're saying you want to sort by the two fields?
0
 

Author Comment

by:chima
ID: 41723733
dipersp, by sort I mean sorting of emails that are in the "Inbox"  The "Rule" is to use the "Search" function within the body of the email.  When it finds these two fields; QA Reviewer (is the first field) and the name of the person assigned to be the QA Reviewer, "name" (this being the second field).
In the Rule's "Search Text" from above, it would look like this;
"QA Reviewer" and
"Joe Smith"
0
 
LVL 9

Expert Comment

by:dipersp
ID: 41723737
Yup, still lost on the sorting.  How are you sorting based on rules?
0
 

Author Comment

by:chima
ID: 41723749
Once the "logic" of the Rule is accomplished, then within the rule setting you can send that email to a specific folder; hence sort the email from all of the others!
0
 
LVL 9

Expert Comment

by:dipersp
ID: 41723757
Ahhh, that helps.  You want to send these to a specific folder.  

So I can think of two options for you.  One is to use the query builder I sent you and use search folders.  While you can't bring them up to the top of your folder list, you can make them favorites and get them to that area of Outlook.

Other option would be to create two rules.  Unfortunate, but it is what it is.  First rule checks for "QA Reviewer".  If found, set a category on the email.  Second rule would look for "Joe Smith" and the QA Reviewer category.  If found, move to XYZ folder.  Then if you have multiple QA Reviewers, you only need multiple copies of the second rule (And copies of the first rule for any other roles you want to handle.)

Again, not elegant, but works since Outlook doesn't give us the AND in the rule (But does when checking multiple criteria.)  

Last thing I noticed in my rules - fourth one down is "With XYZ in the subject or body" then further down the list is "with specific words in the body".  Maybe you could split the phrases between the two?
0
 

Author Comment

by:chima
ID: 41723773
dipersp, the other caveat is that this is not so much for me, but for the members of the "QA Reviewer" group to set up and use.  I am hoping that the set up would not be complicated, because it would turn into a large task to explain the set up to all of the members.  It could be that i would have to set it up for them.  This I do not want to do.
I can't use query builder.  The set up would be difficult for them.
I could use category, I'll have to go see how that would work.
I should have sent this at the beginning;
ruleI would do a "move a copy"  but setting a flag in the Inbox might be better.
0
 

Author Comment

by:chima
ID: 41723777
I would then execute the second portion of the logic on the second folder.  Also, all email have a set subject line and shown "with"
0
 
LVL 9

Accepted Solution

by:
dipersp earned 2000 total points
ID: 41723781
Understood.  Let me know how that goes and maybe we can come up with another option if that doesn't do it.
0
 

Author Comment

by:chima
ID: 41728120
I'll see it this works and I'll get back to you.  thanks
0
 

Author Closing Comment

by:chima
ID: 41733903
I actually found the solution with the application I'm working with, thanks
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question