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 »

3 Quick Methods to Insert Current Date and Time into Your Excel Worksheet

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 »