Office Solutions

How to Traverse a Folder Tree Recursively in Outlook via VBA

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 »

How to Prevent User from Sending Out a Specific Email in Outlook

Using Outlook VBA, learn how to restrict an email being sent out from the user’s Outlook account if specific words are contained in the email body or subject. Identify the Outlook Event to Block the Emails There is often a very pressing requirement of not letting the email sent out from the user’s account, if a specific criterion is met. To be more precise, in large organizations, where data confidentiality is an important concern, the organization might want to block the outgoing...

Read more »

How to Auto Assign a Color Category to New Appointments via Outlook VBA

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,...

Read more »