Rules Based On Numeric Field Values

  • Thread starter Thread starter Tennis Smith
  • Start date Start date
T

Tennis Smith

Hi,

I sometimes get emails which have special standardized notifications in
them. Any "special attention" areas are in a consistent format which will
also contain numbers that are normally 0. If they aren't 0, then there is
some kind of problem. So, the number values can be from 0 to any value. Is
there a way to "flag" these in a rule? Ideally, I'd like to change the
message color of or priority based on the values seen.

Below is partial output from one of the emails with example fields
high-lighted:

Successes : 10
Failures : 0 <====
Aborted : 0 <====
Never ran : 0
Total : 10
Requested : 1 thru 26
Crashes : 0 <====
Pauses : 0
Reloads : 0

Thanks,
-Tennis
 
you'll need to create a series of individual rules to move or flag
messages:

1) if message contains 'Failures : 0' then do this...
2) if message contains 'Failures : 1' then do this...
etc - one per each condition you have. if there is a consistent text that
you can use as a master condition, you could have one rule:

if message contains 'this phrase' and 'Failures : 0' then do this...
else, do that.

If you aren't moving them from the inbox, use views to color them (automatic
formatting), not rules. You only need one custom view and can have at least
25 automatic formatting rules in it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/
 
Hi Diane,

Thanks for the reply. The problem is that any of the numeric field
values can be *anything*. It can be 1 or 9999 or any integer in
between. So, it isn't very practical to build rules for every possible
numeric value.

Could this be done in VBA? Could I search for "Failures" followed by a
number and then set fonts/colors based on that?

TIA,
-Tennis

you'll need to create a series of individual rules to move or flag
messages:

1) if message contains 'Failures : 0' then do this...
2) if message contains 'Failures : 1' then do this...
etc - one per each condition you have. if there is a consistent text that
you can use as a master condition, you could have one rule:

if message contains 'this phrase' and 'Failures : 0' then do this...
else, do that.

If you aren't moving them from the inbox, use views to color them (automatic
formatting), not rules. You only need one custom view and can have at least
25 automatic formatting rules in it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/


Hi,

I sometimes get emails which have special standardized notifications in
them. Any "special attention" areas are in a consistent format which will
also contain numbers that are normally 0. If they aren't 0, then there is
some kind of problem. So, the number values can be from 0 to any value.
Is
there a way to "flag" these in a rule? Ideally, I'd like to change the
message color of or priority based on the values seen.

Below is partial output from one of the emails with example fields
high-lighted:

Successes : 10
Failures : 0 <====
Aborted : 0 <====
Never ran : 0
Total : 10
Requested : 1 thru 26
Crashes : 0 <====
Pauses : 0
Reloads : 0

Thanks,
-Tennis
Click to expand...
Click to expand...
 
Go to outlookcode.com and learn what is known about affecting views using
VBA. Note that you have limited colors available regardless of how you do
it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/


Tennis Smith said:
Hi Diane,

Thanks for the reply. The problem is that any of the numeric field values
can be *anything*. It can be 1 or 9999 or any integer in between. So, it
isn't very practical to build rules for every possible numeric value.

Could this be done in VBA? Could I search for "Failures" followed by a
number and then set fonts/colors based on that?

TIA,
-Tennis

you'll need to create a series of individual rules to move or flag
messages:

1) if message contains 'Failures : 0' then do this...
2) if message contains 'Failures : 1' then do this...
etc - one per each condition you have. if there is a consistent text that
you can use as a master condition, you could have one rule:

if message contains 'this phrase' and 'Failures : 0' then do this...
else, do that.

If you aren't moving them from the inbox, use views to color them
(automatic
formatting), not rules. You only need one custom view and can have at
least
25 automatic formatting rules in it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/


Hi,

I sometimes get emails which have special standardized notifications in
them. Any "special attention" areas are in a consistent format which
will
also contain numbers that are normally 0. If they aren't 0, then there
is
some kind of problem. So, the number values can be from 0 to any value.
Is
there a way to "flag" these in a rule? Ideally, I'd like to change the
message color of or priority based on the values seen.

Below is partial output from one of the emails with example fields
high-lighted:

Successes : 10
Failures : 0 <====
Aborted : 0 <====
Never ran : 0
Total : 10
Requested : 1 thru 26
Crashes : 0 <====
Pauses : 0
Reloads : 0

Thanks,
-Tennis
Click to expand...
Click to expand...
Click to expand...
 
Thanks Diane,

I'll have a look.

-T

Go to outlookcode.com and learn what is known about affecting views using
VBA. Note that you have limited colors available regardless of how you do
it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/


Hi Diane,

Thanks for the reply. The problem is that any of the numeric field values
can be *anything*. It can be 1 or 9999 or any integer in between. So, it
isn't very practical to build rules for every possible numeric value.

Could this be done in VBA? Could I search for "Failures" followed by a
number and then set fonts/colors based on that?

TIA,
-Tennis

you'll need to create a series of individual rules to move or flag
messages:

1) if message contains 'Failures : 0' then do this...
2) if message contains 'Failures : 1' then do this...
etc - one per each condition you have. if there is a consistent text that
you can use as a master condition, you could have one rule:

if message contains 'this phrase' and 'Failures : 0' then do this...
else, do that.

If you aren't moving them from the inbox, use views to color them
(automatic
formatting), not rules. You only need one custom view and can have at
least
25 automatic formatting rules in it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/



Hi,

I sometimes get emails which have special standardized notifications in
them. Any "special attention" areas are in a consistent format which
will
also contain numbers that are normally 0. If they aren't 0, then there
is
some kind of problem. So, the number values can be from 0 to any value.
Is
there a way to "flag" these in a rule? Ideally, I'd like to change the
message color of or priority based on the values seen.

Below is partial output from one of the emails with example fields
high-lighted:

Successes : 10
Failures : 0 <====
Aborted : 0 <====
Never ran : 0
Total : 10
Requested : 1 thru 26
Crashes : 0 <====
Pauses : 0
Reloads : 0

Thanks,
-Tennis
Click to expand...
Click to expand...
Click to expand...
 
Back
Top