Office Solutions

How to Prevent Assigning a Specific Category to Unsuitable Emails in Outlook

Some users complain that they always assign color categories to unsuitable mails in Outlook. Focused on this issue, this article will introduce a solution which uses VBA. If you prefer to assign color categories manually in Outlook, it is nearly inevitable that you may color categorize items incorrectly by accident at times. Also, maybe you don’t realize this mistake until a long time later. For instance, you’ve created a specific color category named “Test”, which is specifically...

Read more »

How to Batch Import Birthdays from Excel to the Corresponding Outlook Contacts

If you have an excel file which contains the information of many contacts, including their birthdays, and you want to import the birthdays to corresponding contacts in your Outlook, you can use the method introduced in this article. Perhaps you have an Excel worksheet which is recording the information of many of your colleagues, including their respective birthdays. Therefore, now, you wish to quickly add these birthdays to the corresponding Outlook contacts. If there are no according...

Read more »

How to Open and Populate Template with Excel VBA

Excel Templates are typically workbooks, with a reporting framework, often supported by functions. A templates (xltx) can be used over and again without polluting it with data. After population with data, a template workbook is saved as an xlsx, preserving the virgin state of the xltx itself. In this exercise we will use VBA code  to open and populate a template. The template can be found here and Excel Macro used can be found here. This article assumes the reader has the Developer...

Read more »