How to Replace the Color Category of an Outlook Item with VBA

If you want to replace the color category of an Outlook item, you’ll need to remove the original one as a new category is assigned. Thus, in this article, we will teach you how to automate this via VBA. The primary reason why we make use of color categories in Outlook is to better classify and manage your Outlook items. Plus, Outlook permits us to assign one or more color categories to one item. However, too many categories assigned to a single item may sometimes clutter up your...

Read more »

How to Auto Count the Attendees before Sending a Meeting Invitation in Your Outlook

This article will teach you how to utilize Outlook VBA to automatically get a count of attendees before sending out a meeting invitation.  Similar to count the recipients before sending out an email, some users also wish to count the attendees before sending a meeting invitation. As usual, this aims to estimate the total cost of the proposed meeting and then decide if to send such a meeting invitation to the attendees. Moreover, since Outlook permits users to set attendees as required or...

Read more »

How to Extract & Show All Hyperlink Addresses in an Email via Outlook VBA

Most of time, to view the hyperlink addresses, you need to hover the cursor over the displaying text. This article will teach you to use VBA to show all the addresses in one email simply by one click. As you know, apart from directly adding a URL in the email body, you’re allowed to insert hyperlink to texts. In this case, you will be unable to view the hyperlink addresses straightly. You need to hover the cursor over the displaying text. But, it will be quite tedious if there are too many...

Read more »