realmofconfusion
New Member
- Outlook version
- Outlook 365 64 bit
- Email Account
- Office 365 Exchange
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. I don't want to press a button to make the changes, I'm after a way to automatically remove the "TO ACTION" category whenever the "COMPLETED" category 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.
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. I don't want to press a button to make the changes, I'm after a way to automatically remove the "TO ACTION" category whenever the "COMPLETED" category 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.