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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |