Feb 15 2024 12:38 PM
Though i wrote a lot of code for an Excel project i created to help me keep track of my work, i am pretty much useless when it comes to Outlook, and it would seem Microsoft doesn't like my ideas...
I have a substantial email folder hierarchy. For example, lets say there is a main folder named "Finance", a subfolder to Finance named "Credit Cards", and a few folders off of Credit Cards - say "AMEX", "Chase" and "BoA".
Now to keep everything incoming neat and tidy, i have rules. One rule will take any incoming email from AMEX and stick it in the AMEX folder-
Finance
Credit Cards
AMEX
And so AMEX gets highlighted (shows in bold) due to the new email, but not "Credit Cards" nor "Finance", so if we have that branch collapsed with only Finance showing, we have no tree indication that there is a new email in one of the branches.
I want:
Finance
Credit Cards
AMEX
which even if collapsed would still show
Finance
not
Finance
Is there a forum that would be able to help teach me how to write VBA so when something new is dropped into a branch the entire lineage gets highlighted, and when it is becomes read the branch goes back to plain text? Wanting to tweak things in Excel was how i learned that (with MUCH trial and error), so i guess this would be a good place to start here!
Thank you for your consideration!
Best Regards,
-Bruce