Setting RULES with more than one condition in MS OUTLOOK

Status
Not open for further replies.

Abdullah

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
When setting rules, Outlook only gives you the option to check specific words in the body of an email....but uses the "OR" statement. If I want to specify 5 criteria that needs to be checked as "and" and not "or", how do I that in Microsoft Outlook?
The current problem is that when you set 5 criteria, if one criteria is met, then whatever rule you have set is proved true and activates the rule. I want 5 criteria and each must be true before the rule activates.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Rules are OR'd within the same condition and AND'd if you use different conditions.
From Billy or Sue AND subject contains the word Hello.

if you want to find mail sent to Billy and Sue, you would need to use a view or search folder, both of which have a better filter.
 

Abdullah

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thank you Diane...I am setting up a rule in Outlook....not a search pattern...
I need to filter an email response on 5 criteria "specific words within the body"...but all it does is use "or" as the operator rather than "and"...and so my email filter fails if one of the conditions is met....I want all 5 criteria within the same condition to be true...why does Outlook not have this? Clearly from your answer, it does not...so what is an alternative way that I can do this? I am not a programmer or understand all the fancy VB routines...can you help?
 

Forum Admin

Senior Member
I have no idea why it's not in it - rules were added back in the Outlook 2000 time frame and haven't really changed much since, save for adding more conditions and actions. They haven't edited any existing conditions.

I'm not sure if a run a script rule would be efficient but there is at least one rules replacement utility that might work - auto-mate.

Can't pass up an interesting macro idea. :) This worked for me in a simple test. If all words in the array are anywhere in the body, it popped up the dialog box. If one word was missing, it did not.

If you have a specific condition in addition to the words in the body, look for that in the rule - if there are no other conditions, put one of the words in the rule, so the script processes fewer messages.

The only actions should be in this script.
More info: http://www.slipstick.com/outlook/rules/outlooks-rules-and-alerts-run-a-script/

Code:
Sub CheckForAll(Item As Outlook.MailItem)
    Dim strID As String
    Dim strTest As String
    Dim arr As Variant
    Dim objMail As Outlook.MailItem
    
    strID = Item.EntryID
    Set objMail = Application.Session.GetItemFromID(strID)
' Set up the array
arr = Array("outlook", "work", "key3")
' Go through the array and look for a match, then do something
For i = LBound(arr) To UBound(arr)
    If InStr(1, LCase(objMail.Body), arr(i)) = 0 Then
    Exit Sub
    End If
Next i

' do whatever
MsgBox "All Match"

Set objMail = Nothing
End Sub
 

Abdullah

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thank you so much Diane...you are getting me to a solution very fast....so the purpose of my rule is...for an incoming email with a specific wording in the subject line (I got this part under control) , if true, then check if the following headers appear in the body of the email (In the code that you included to your reply, how do I use what you have sent me for my purpose..., where/how do I edit for my purpose.)

Company name
Name of sender
Telephone number
Landline number
Physical Address


If all true, then have server reply etc...(I have this part under control)
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B Setting rules Using Outlook 1
G Setting Office Outlook e-mail to obey Word rules Using Outlook 1
R Problem setting rules Full Access rights user bij Auto Mapping Shared mailboxes feature Exchange Server Administration 1
R Outlook 2003 - setting rules using 'wild' characters Using Outlook 2
P OWA Settings->Calendar->Events from Email; Setting changes do not hold Using Outlook 1
Marc2019 Setting up an Outlook Account on Mac Os 10.6.8 Outlook 2011 Using Outlook 1
L Outlook Office 365 client: won't remember my setting File, not to collapse ribbon Using Outlook 2
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
llama_thumper Setting up forwarders on Exchange server Exchange Server Administration 0
C iCloud Setting missing Outlook tab and Outlook missing the iCloud refresh button Using Outlook 4
B Setting defaults Using Outlook 2
C need help setting up outlook first time Using Outlook 1
P Reading Pane (Reading Pain?) Default Setting Using Outlook 1
W Setting up a custom form Outlook VBA and Custom Forms 2
mctabish Setting "Reply To" based on inbox Outlook VBA and Custom Forms 2
R Setting font and color used when replying to an email Outlook VBA and Custom Forms 3
M Setting flag follow up for next business day Outlook VBA and Custom Forms 1
Ed Sheehan Unusual behaviour in setting Sender (Outlook 2016) Outlook VBA and Custom Forms 4
Jennifer Murphy Equations don't comply with style setting to left justify Using Outlook 0
J Setting default address book Using Outlook 0
N Does a Shared Folder Policy override a Digital Signature Setting for macros? Outlook VBA and Custom Forms 6
Diane Poremsky Setting up an Outlook.com IMAP account New Slipstick.com Articles 0
Diane Poremsky Setting the default Country for Outlook Contacts New Slipstick.com Articles 0
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
Diane Poremsky Adjusting Outlook's Zoom setting in Email New Slipstick.com Articles 0
O Setting default format for composing/replying to emails Using Outlook 3
B Outlook Calendar/setting appointments Using Outlook 1
Diane Poremsky Adjusting Outlook's Zoom setting in Email New Slipstick.com Articles 0
Diane Poremsky Setting Custom Reminder Times New Slipstick.com Articles 0
A Can't stop Outlook.com from setting reminders on appointments? Using Outlook.com accounts in Outlook 3
L Setting up my PA's Outlook Using Outlook 7
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
N "Instant Search" setting a default view Using Outlook 3
H SETTING UP A "NEW" NEVER HAD NEVER USED EMAIL ACCOUNT Using Outlook 9
K Setting Default Email Address for Meeting Replies Using Outlook 3
S Setting up Outlook 2010 to work with custom domain outlook.com account BCM (Business Contact Manager) 3
D Setting defult "Show a room list" Using Outlook 0
Horsepower Setting appointments in calendar Using Outlook 3
J Setting tabs in contacts / notes field Using Outlook 0
T Setting a Default Subject from a certain Signature Using Outlook 0
K Help Needed - setting up Email in Outlook 2013 Using Outlook 3
mikecox setting Default area code in Contacts Using Outlook 5
G Outlook2013 - "From" name doesn't change even when changed in Account Setting Using Outlook 4
D How do I start completely from scratch in setting up Outlook 2013? Using Outlook 6
V View zoom setting changing Using Outlook 1
C Setting up Outlook 10 on Widows 8 using Google Server Using Outlook 3
I Outlook Appointments - Setting default text in message body Using Outlook 3
T Setting Color codes for each user of a shared Calendar Using Outlook 1
J setting date in drafts Using Outlook 4
J Outlook 2010 - email address disappears when setting up new contact Using Outlook 0
Similar threads


















































Top