|
| 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 | Search this Thread | Display Modes |
|
|
|
#1
July 18th 07, 07:48 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Apply a Flag Status automatically
Is it possible to assign a flag status to an email that arrives ... on a
rotational basis?? I.e. Message 1 - Flag Status of Blue, Message 2 - Flag Status of Orange, Message 3 - Flag Status of Red, Message 1 - Flag Status of Blue .. etc etc?? Any help would be very gratefully received. 
|
|
#2
July 18th 07, 08:45 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Apply a Flag Status automatically
If that's on a daily basis, assuming that you start Outlook not more than once a day, you can store the current value on the module level. Start the value with 1, that is set it to olPurpleFlagIcon in the Startup event. In the ItemAdd event of the Inbox set the item's FlagIcon property to the current value, then increase its value by 1. If the value is bigger than 6 (olRedFlagIcon) then set it back to 1. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Organize eMails: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Tue, 17 Jul 2007 22:48:02 -0700 schrieb tog: Is it possible to assign a flag status to an email that arrives ... on a rotational basis?? I.e. Message 1 - Flag Status of Blue, Message 2 - Flag Status of Orange, Message 3 - Flag Status of Red, Message 1 - Flag Status of Blue .. etc etc?? Any help would be very gratefully received.
|
|
#3
July 18th 07, 11:27 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Apply a Flag Status automatically
Hi Michael ...
THANKS for the reply ... I guess I wasn't descriptive enough ... basically when an email arrives .. so it could be 1 or a 100 times a day (more likely the latter!) each new email is assigned a colour ... based on the loop I mentioned. If the way you suggest is the way ... then I'll start working out what the heck you were referring to!  I love a challenge! "Michael Bauer [MVP - Outlook]" wrote: If that's on a daily basis, assuming that you start Outlook not more than once a day, you can store the current value on the module level. Start the value with 1, that is set it to olPurpleFlagIcon in the Startup event. In the ItemAdd event of the Inbox set the item's FlagIcon property to the current value, then increase its value by 1. If the value is bigger than 6 (olRedFlagIcon) then set it back to 1. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Organize eMails: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Tue, 17 Jul 2007 22:48:02 -0700 schrieb tog: Is it possible to assign a flag status to an email that arrives ... on a rotational basis?? I.e. Message 1 - Flag Status of Blue, Message 2 - Flag Status of Orange, Message 3 - Flag Status of Red, Message 1 - Flag Status of Blue .. etc etc?? Any help would be very gratefully received.
|
|
#4
July 19th 07, 08:28 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Apply a Flag Status automatically
For me, rotational means the first e-mail gets color 1, the second color 2 etc. Because there are only 5 colors the sixth e-mail must get color 1 again. If you have a question, please ask. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Organize eMails: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Wed, 18 Jul 2007 02:27:01 -0700 schrieb tog: Hi Michael ... THANKS for the reply ... I guess I wasn't descriptive enough ... basically when an email arrives .. so it could be 1 or a 100 times a day (more likely the latter!) each new email is assigned a colour ... based on the loop I mentioned. If the way you suggest is the way ... then I'll start working out what the heck you were referring to! I love a challenge! "Michael Bauer [MVP - Outlook]" wrote: If that's on a daily basis, assuming that you start Outlook not more than once a day, you can store the current value on the module level. Start the value with 1, that is set it to olPurpleFlagIcon in the Startup event. In the ItemAdd event of the Inbox set the item's FlagIcon property to the current value, then increase its value by 1. If the value is bigger than 6 (olRedFlagIcon) then set it back to 1. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Organize eMails: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Tue, 17 Jul 2007 22:48:02 -0700 schrieb tog: Is it possible to assign a flag status to an email that arrives ... on a rotational basis?? I.e. Message 1 - Flag Status of Blue, Message 2 - Flag Status of Orange, Message 3 - Flag Status of Red, Message 1 - Flag Status of Blue .. etc etc?? Any help would be very gratefully received.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Moving Flag Status flag in Outlook 2007 | Gary C. | Outlook - Installation | 1 | June 20th 07 12:13 AM |
| Outlook 2003 - flag status | no spam | Outlook - General Queries | 5 | April 2nd 07 05:08 AM |
| setting status flag programmatically | Dasha | Outlook and VBA | 7 | February 2nd 07 09:37 AM |
| Group By Flag Status and then Received date | [email protected] | Outlook - General Queries | 0 | June 10th 06 01:53 AM |
| Contact Flag Status | Guy | Outlook and VBA | 1 | May 13th 06 07:27 AM |
Hybrid Mode
