Hi folks, hope you can help. I'm very familiar with Excel VBA, but never done anything in Outlook before.

What I'm after, assuming it's possible, is a macro that will clear a specific category whenever another, different, category is set. Specifically, if I have an email that's been set to category blue ("TO ACTION"), then if I apply category yellow ("COMPLETED"), then I want the existing "TO ACTION" category to clear, so that only the "COMPLETED" category/status is set.

Setting the categories manually just applies both, so what I'm after is a way to clear one when the other is set.

Most of what I've learned of Excel VBA is through a combination of trial and error and using the macro recorder to get an idea of the code, but Outlook doesn't have a macro recorder, so I'm at a loss as to what specific commands are required.

Any assistance will be greatly appreciated.