Office Solutions

How to Add an Object Library Reference in VBA

In Outlook VBA editor, if you desire to use the objects of other applications, such as Microsoft Excel or Word, you have to add the according object library references in the first place. This article will share you the concrete steps. To start with, you could access the Outlook VBA editor either by pressing "Alt + F11" keys or clicking on the “Visual Basic” button in the “Developer” ribbon. Then, you can follow the steps below to establish the reference to your wanted objects. Here...

Read more »

How to Run VBA Code in Your Outlook

At times you may wish to utilize VBA code in Outlook to achieve more functions. Yet, you do not know how to run VBA code in your Outlook. Thus, this article will expose the detailed steps to you. Thereinafter, we will take Outlook 2010 version as an example and show you the elaborate steps, ranging from modifying macro security settings to running VBA code. Now, read on to get them. Step 1: Enable “Developer” Tab First of all, after launching Outlook, access “File” menu. ...

Read more »

How to Batch Replace One Color Category with Another for All Outlook Items

If you want to replace one color category with another for all Outlook items, you must long for a way that allows you to achieve this in bulk, instead of manually doing it. Now, this article will show you such a method. Have you ever wished to quickly replace one color category with another for all items in your Outlook? For example, if you want to abandon and delete a color category from your Outlook, you may want to replace it with another on all items before deleting. Without any doubts,...

Read more »