In this article, we will give you detailed instructions of how to digitally sign your Word macro project.
By and large, Word disables all macros and pops up notifications whenever we show the intention to run one. This means we have to personally confirm the operation every time we open a Word document containing a macro, which is not convenient. While on the other hand, if we enable all macros, we are put our files and computer at high risk.
Obviously, neither is perfect. Actually, to...
Read more »
If there are sub folders within main Inbox or Sent Items folder, how to go about traversing them in a recursive and efficient way, using VBA, is a very useful tip. This critical piece is reusable in many other VBA projects.
The Critical Problem of Traversing Folders
Corporate and commercial users of Outlook often end up having hundreds of subfolders beneath their main inbox or sent items folder, with relevant emails in each of those. When there comes a need to go through all those folders to...
Read more »
Many users prefer to manage Outlook appointments by “Color Category” . So they hope that Outlook can auto categorize new appointments. This article will introduce how to realize it.
The article “How to Auto Categorize Appointments in Outlook Calendar” introduces a workaround. It uses Conditional Formatting to color code the appointments. Actually it just assigns a color to the item, not uses color category. Besides, Conditional Formatting relies on view settings. That is to say, if you...
Read more »
