troubleshooting Question

vba to change Outlook so all emails from are red in current Inbox view in 10 client computers.

Avatar of rberke
rberkeFlag for United States of America asked on
4 Comments1 Solution134 ViewsLast Modified:
We have 10 computers using outlook 2010 and 2013. The computers are already configured to run VBA, and the programs are centrally managed in a "Master" vbaProject.otm which is copied daily to each client computer. We are not using MS Exchange.

I want to enforce a new "rule" about email colors: whenever an email comes from or it should show as red in the Inbox on every computer.

I create the rule view use >ribbon > View tab > Current View group > View Settings > Conditional Formatting > Click "Add" to create a view named "Good Domains"
I then use Font to select red
and Condition > Advanced to create two rules  "From contains superdomain"  and "From Contains GoodCustomer"

Perfect.  But now I want to get all 10 computers to honor the new rule view.

Some forums suggest sharing the colorful view with some variation of the following:

1) modify a "master" computer's view as desired.  (It is probably best to modify all 6 views shown in Manage Views.)
2) copy the views to an NearlyEmpty.PST which then gets copied to each client
3) each client then imports that view and applies it to their Inbox.

But that means most of the people will see significant changes to their current Inbox view.   Favorite columns might disappear, and other columns might resize etc.

To avoid this, I might simply go to each computer, open the Inbox then manually key in the desired changes for SuperDomain and GoodCustomer.  

But, if I ever want to add, I must repeat the manual setup 10 times.

So, a better solution would be to have my vba Application_startup subroutine automatically change the inbox view to enforce that rule, while not changing anything else that the user sees.

I hope someone here has some code to get me started on this.

"Batchelor", Developer and EE Topic Advisor
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros