|
outlook
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Rules Based On Numeric Field ValuesI 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. 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. > > 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. > > > > 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. >> > >> > > 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. > >> > > >> > > > >
Other interesting topics
|
|||||||||||||||||||||||