How configure masive Outlook local rules

[Roberto]

Hello
I will appreciate help on the following subject.
My department manager desires each mail from his Outlook mailbox, to appear in red colour, in all intranet department PC user
The Exchange administrator can´t put server side rules by some corporative policies. So, Is there any kind of program,(perhaps in Outlook VBA) that can run in each PC user, to configure local rules and obtain that behaviour ?. In this case, which are the Outlook objects to use ? The idea is avoiding round personally through 100 users desktops setting rule by rule. (The problem will grow when some changes arise, for example adding others colours.
Thanks in advance.Roberto

 

[Andrew Cushen]

Roberto-

The situation you describe is best handled by Exchange
rules. If you try to solve it by using VBA programming on
the Clients, you will have to distribute some sort of add-
in to all the users anyway- or deal with the nightmare of
going around to all the users' PCs and setting the Rules
by hand for each user.

If you are determined to do it on the client end, the
recommended method for distributing VB/VBA code in Outlook
is to create a COM add-in: have a look at
http://www.outlookcode.com/d/comaddins.htm . You would
have to compile the Add-in with VB6 or Office Developer,
then install it on all users' PCs.

As far as changing the color of the flags, "Steve"
<[email protected]> posted this code on the Outlook
programming newsgroup:

'---------------------------------------------------------
This code changes an items flag to Yellow. Colored flag
work with Outlook
2003 only, as Outlook 2002 supports red flags only. Other
flags possible
are: olBlueFlagIcon, olGreenFlagIcon, olOrangeFlagIcon,
olPurpleFlagIcon,
olRedFlagIcon

Set ol = New Outlook.Application
Set olns = ol.GetNamespace("MAPI")
Set item = olns.GetItemFromID(EntryID, StoreID)

With item
.FlagIcon = olYellowFlagIcon
.FlagStatus = olFlagMarked
.Save
End With

Set ol = Nothing
Set olns = Nothing
Set Item = Nothing
'-------------------------------------------------------


AFAIK there is no way to set up, or interact with, Rules
from VBA.

HTH,

-Andrew
================================================

-----Original Message-----
Hello:
I will appreciate help on the following subject.
My department manager desires each mail from his Outlook

mailbox, to appear in red colour, in all intranet
department PC user.

The Exchange administrator can´t put server side rules

by some corporative policies. So, Is there any kind of
program,(perhaps in Outlook VBA) that can run in each PC
user, to configure local rules and obtain that
behaviour ?. In this case, which are the Outlook objects
to use ? The idea is avoiding round personally through
100 users desktops setting rule by rule. (The problem will
grow when some changes arise, for example adding others
colours.)

 

[Charlie]

I don't believe that this can be achieved by creating a rule. You will likely want to create another view, regardless if this is performed manually or by VBA. To see what I mean by view, in Outlook 2k3 go to View, Arrange By, Current View, Customize Current View or Define Views. Within the Custom Views dialog you can use the Automatic Formatting feature to 'color' messages from specific groups of people or by practically any other criteria. Within the Outlook library you can use the View and Views classes in creating your solution.

Good luck.