Changing colors of emails in Outlook 2007 - based on replied to status

Question

My manager would like to have any emails he hasn't replied to or forwarded within 24 hours of receipt to turn yellow and then red if he hasn't dealt with them within 48 hours.

I've gone through the various rule scenarios and cannot find a field I can use for "Replied" or "Forwarded" ...

I've looked at flagging all incoming emails for action "Today" and that turns all untouched emails red if they go past Close of Business, but it also adds all of his emails to his task list - which made the top of his head explode, so I had to remove that rule.

Any suggestions? I'm at the limit of my limited expertise with Outlook Rules. I'm willing to look at coding something if someone has VERY specific code samples I can cut, paste and modify.

Answer 1

You can't do this with Rules and Alerts as you can't do conditional formatting. You can do this via .NET and have that run via Scheduled tasks but for actual code you would be better going to Stack Overflow.

Or, do it via a macro (how to create a macro) and have the macro scheduled. Again, you should head to Stack Overflow for actual code but do some research first as you'll probably find it is achievable.

General color changing guide by VBA