Creating Rules with "AND" as a connector rather than "OR"

T

TH287

I want to create a rule that is activated when I have two words in the
subject or the message body. The rule is no good to me if it has just one of
the two words, so I need an "AND", but all I can seem to get is "OR". How
can I create such a rule?
 
D

Diane Poremsky [MVP]

Rules do not support AND within the same field. if the two words are a
phrase ("outlook newsgroup") you can enclose them in quotes but if they can
be anywhere in the message it won't work.

If you use Outlook 2003 or 2007 you can use search folders instead -enable
the QueryBuilder and its really easy to write AND filters. See
http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]
 
D

Diane Poremsky [MVP]

Whether you use an AND or OR depends on the field - its not usually
customizable in rules. The same applies to filters - within a field (ie,
subject) the words are OR'd together but within two different fields
(subject and body) the criteria is AND'd. Comma = OR.
http://www.outlook-tips.net/archives/2004/20041229.htm

In filters, use the Querybuilder to make it easier - see
http://www.outlook-tips.net/archives/2004/20040927.htm




--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]
 
J

jss

I'm trying to get organized, and the rules and search folders help, but I
haven't found them very powerful.

The query builder for search folders does look a little better but seems to
be missing things like "text in message header". It does at least work on
sent messages. It would be nice if they could search archive folders.

To use search folders this way, I would leave everything in the inbox and
sent messages, and create scores, maybe hundreds, of search folders for
customers, vendors, etc. Will these searches have to run through the whole
inbox again and again?

I now look through the unread messages search folder and see what folder a
message has been moved to. If it is still in the inbox, due to no rule, or
any other reason, I right click and move it and maybe try to work on the
rule. Can I see what 'search folder', if any, a mesage is in? I don't want
to have look for unread messages in all these scores of search folders.

I've been using Outlook for years, but am only recently trying to make it
really do some work for me. If you have any links to practical advice, I'd
appreciate them.

John


Diane Poremsky said:
Rules do not support AND within the same field. if the two words are a
phrase ("outlook newsgroup") you can enclose them in quotes but if they
can be anywhere in the message it won't work.

If you use Outlook 2003 or 2007 you can use search folders instead -enable
the QueryBuilder and its really easy to write AND filters. See
http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

TH287 said:
I want to create a rule that is activated when I have two words in the
subject or the message body. The rule is no good to me if it has just
one of
the two words, so I need an "AND", but all I can seem to get is "OR".
How
can I create such a rule?
 
D

Diane Poremsky [MVP]

Search folders are not real folders - they are virtual folders and can
search the entire mailbox or PST. You can move mail to other folders to
clear out the inbox and as long as they remain in the the same message
store, search folders will find it. (Each message store can have its own
search folders, they just can't search across stores.) There is no need to
"see" what search folder a message is in - just a pointer to the message is
in the search folder. The message remains in the folder where it was all
along.

As long as you use the search folder weekly, they will index messages as
they arrive. If you don't use a folder weekly, then there will a short wait
as it does the search.

Messages headers are not searchable. If I need to find words in a message
header, I use Rules and Run Rules Now, either flagging or adding a category
to messages that have the words, then use search folders to find them.
(Much of how outlook deals with headers goes back to its days primarily as
an exchange client, when high volumes of mail was internal - there is no
message header on internal mail, so no need to view it or search it. The
average end user didn't need to review it either.)




--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

jss said:
I'm trying to get organized, and the rules and search folders help, but I
haven't found them very powerful.

The query builder for search folders does look a little better but seems
to be missing things like "text in message header". It does at least work
on sent messages. It would be nice if they could search archive folders.

To use search folders this way, I would leave everything in the inbox and
sent messages, and create scores, maybe hundreds, of search folders for
customers, vendors, etc. Will these searches have to run through the whole
inbox again and again?

I now look through the unread messages search folder and see what folder a
message has been moved to. If it is still in the inbox, due to no rule, or
any other reason, I right click and move it and maybe try to work on the
rule. Can I see what 'search folder', if any, a mesage is in? I don't want
to have look for unread messages in all these scores of search folders.

I've been using Outlook for years, but am only recently trying to make it
really do some work for me. If you have any links to practical advice, I'd
appreciate them.

John


Diane Poremsky said:
Rules do not support AND within the same field. if the two words are a
phrase ("outlook newsgroup") you can enclose them in quotes but if they
can be anywhere in the message it won't work.

If you use Outlook 2003 or 2007 you can use search folders
instead -enable the QueryBuilder and its really easy to write AND
filters. See http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

TH287 said:
I want to create a rule that is activated when I have two words in the
subject or the message body. The rule is no good to me if it has just
one of
the two words, so I need an "AND", but all I can seem to get is "OR".
How
can I create such a rule?
 
J

jss

Thanks for the explanation.

I think search folders will be problematic. Since I would have so many
search folders, they may not all be used weekly. Also, I'd like some
assurance that the rules/criteria worked and the message was actually
assigned to the correct folder(s). If I could tell that the rule did not
work, I could assign a category.

I'll check your "fix Outlook 2010" link. Maybe on the next cycle MS will
make some changes beyond the interface.


Diane Poremsky said:
Search folders are not real folders - they are virtual folders and can
search the entire mailbox or PST. You can move mail to other folders to
clear out the inbox and as long as they remain in the the same message
store, search folders will find it. (Each message store can have its own
search folders, they just can't search across stores.) There is no need to
"see" what search folder a message is in - just a pointer to the message
is in the search folder. The message remains in the folder where it was
all along.

As long as you use the search folder weekly, they will index messages as
they arrive. If you don't use a folder weekly, then there will a short
wait as it does the search.

Messages headers are not searchable. If I need to find words in a message
header, I use Rules and Run Rules Now, either flagging or adding a
category to messages that have the words, then use search folders to find
them. (Much of how outlook deals with headers goes back to its days
primarily as an exchange client, when high volumes of mail was internal -
there is no message header on internal mail, so no need to view it or
search it. The average end user didn't need to review it either.)




--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34

jss said:
I'm trying to get organized, and the rules and search folders help, but I
haven't found them very powerful.

The query builder for search folders does look a little better but seems
to be missing things like "text in message header". It does at least
work on sent messages. It would be nice if they could search archive
folders.

To use search folders this way, I would leave everything in the inbox and
sent messages, and create scores, maybe hundreds, of search folders for
customers, vendors, etc. Will these searches have to run through the
whole inbox again and again?

I now look through the unread messages search folder and see what folder
a message has been moved to. If it is still in the inbox, due to no rule,
or any other reason, I right click and move it and maybe try to work on
the rule. Can I see what 'search folder', if any, a mesage is in? I don't
want to have look for unread messages in all these scores of search
folders.

I've been using Outlook for years, but am only recently trying to make it
really do some work for me. If you have any links to practical advice,
I'd appreciate them.

John


Diane Poremsky said:
Rules do not support AND within the same field. if the two words are a
phrase ("outlook newsgroup") you can enclose them in quotes but if they
can be anywhere in the message it won't work.

If you use Outlook 2003 or 2007 you can use search folders
instead -enable the QueryBuilder and its really easy to write AND
filters. See http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

I want to create a rule that is activated when I have two words in the
subject or the message body. The rule is no good to me if it has just
one of
the two words, so I need an "AND", but all I can seem to get is "OR".
How
can I create such a rule?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top