A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Rules Based On Numeric Field Values



 
 
Thread Tools Display Modes
  #1  
Old May 6th, 2005, 04:15 PM
Tennis Smith
external usenet poster
 
Posts: n/a
Default Rules Based On Numeric Field Values

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.


  #2  
Old May 6th, 2005, 04:38 PM
Diane Poremsky [MVP]
external usenet poster
 
Posts: n/a
Default

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" 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.




  #3  
Old May 7th, 2005, 11:24 AM
Tennis Smith
external usenet poster
 
Posts: n/a
Default

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]" wrote in
message :

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" 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.



  #4  
Old May 7th, 2005, 03:44 PM
Diane Poremsky [MVP]
external usenet poster
 
Posts: n/a
Default

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" 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]" wrote in message
:

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" 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.





  #5  
Old May 7th, 2005, 05:26 PM
Tennis Smith
external usenet poster
 
Posts: n/a
Default

Thanks Diane,

I'll have a look.

-T

"Diane Poremsky [MVP]" wrote in
message :

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" 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]" wrote in message
:


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" 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.





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Design help, please SillySally Using Forms 27 March 6th, 2005 05:11 AM
Looking up a value in a table based on two field values? How? Richard Horne General Discussion 10 November 4th, 2004 03:29 PM
Showing values based on underlying field data ChrisJ Running & Setting Up Queries 2 November 2nd, 2004 12:54 AM
settign unbound checkboxes based on text field entry Richard Setting Up & Running Reports 2 October 29th, 2004 12:28 AM
New Record Update Michelle Using Forms 5 October 28th, 2004 07:59 AM


All times are GMT +1. The time now is 05:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.