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 »
When you are working on your Excel file, you will probably have a need to note down the current date and time. Therefore, here we will discuss about 3 methods to achieve this task.
Knowing when you have modified a file is very important for you to track changes. Thus, sometimes you will insert the current date and time into a worksheet to make a mark. Instead of manually inserting date and time into cells, you can also use the three methods in this article. And in the coming passage, we...
Read more »
