View Single Post
  #4  
Old July 19th 07, 08:28 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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.


Ads