Home All Groups Group Topic Archive Search About

Rules Based On Numeric Field Values

Author
6 May 2005 3:15 PM
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

--
Remove "-remove-to-reply" to respond to my  email address directly.

Author
6 May 2005 3:38 PM
Diane Poremsky [MVP]
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)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/


"Tennis Smith" <tennis_sm***@yahoo-remove-to-reply.com> wrote in message
news:1115392902.435875@sj-nntpcache-3...
Show quote
> 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
>
> --
> Remove "-remove-to-reply" to respond to my  email address directly.
>
>
Author
7 May 2005 10:24 AM
Tennis Smith
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

Show quote
"Diane Poremsky [MVP]" <diane.poremsky+msn***@gmail.com> wrote in
message news:diane.poremsky+msnews@gmail.com:

> 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)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Join OneNote Tips mailing list: http://www.onenote-tips.net/
>
>
> "Tennis Smith" <tennis_sm***@yahoo-remove-to-reply.com> wrote in message
> news:1115392902.435875@sj-nntpcache-3...
>
> > 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
> >
> > --
> > Remove "-remove-to-reply" to respond to my  email address directly.
> >
> >
Author
7 May 2005 2:44 PM
Diane Poremsky [MVP]
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)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/


"Tennis Smith" <tennis_sm***@yahoo-remove-to-reply.com> wrote in message
news:1115461814.518883@sj-nntpcache-3...
Show quote
> 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
>
> "Diane Poremsky [MVP]" <diane.poremsky+msn***@gmail.com> wrote in message
> news:diane.poremsky+msnews@gmail.com:
>
>> 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)
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> Join OneNote Tips mailing list: http://www.onenote-tips.net/
>>
>>
>> "Tennis Smith" <tennis_sm***@yahoo-remove-to-reply.com> wrote in message
>> news:1115392902.435875@sj-nntpcache-3...
>>
>> > 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
>> >
>> > --
>> > Remove "-remove-to-reply" to respond to my  email address directly.
>> >
>> >
>
Author
7 May 2005 4:26 PM
Tennis Smith
Thanks Diane,

I'll have a look.

-T

Show quote
"Diane Poremsky [MVP]" <diane.poremsky+msn***@gmail.com> wrote in
message news:diane.poremsky+msnews@gmail.com:

> 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)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Join OneNote Tips mailing list: http://www.onenote-tips.net/
>
>
> "Tennis Smith" <tennis_sm***@yahoo-remove-to-reply.com> wrote in message
> news:1115461814.518883@sj-nntpcache-3...
>
> > 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
> >
> > "Diane Poremsky [MVP]" <diane.poremsky+msn***@gmail.com> wrote in message
> > news:diane.poremsky+msnews@gmail.com:
> >
>
> >> 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)
> >>
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >> Join OneNote Tips mailing list: http://www.onenote-tips.net/
> >>
> >>
> >> "Tennis Smith" <tennis_sm***@yahoo-remove-to-reply.com> wrote in message
> >> news:1115392902.435875@sj-nntpcache-3...
> >>
>
> >> > 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
> >> >
> >> > --
> >> > Remove "-remove-to-reply" to respond to my  email address directly.
> >> >
> >> >
>
> >

AddThis Social Bookmark Button