Office Solutions

2 Methods to Batch Send Outlook Email to All Contacts in a Specific Color Category

If you would like to send Outlook email to all contacts in a specific color category in batches, you could utilize the 2 methods introduced in this article. For some reasons, at times, you may need to send a same email to all contacts in a specific color category. Without any doubts, sending one by one is pretty tedious. Hence, here we will share you 2 approaches. Both have their own pros and cons, you could choose either to your liking. Method 1: Batch Send to All Contacts in a...

Read more »

2 Quick Ways to Count the Number of Highlighted Words in Your Word Document

In this article, we would like to offer you 2 quick ways to count the number of highlighted words in your Word document. From time to time, we would highlight texts in different topics with different colors. In case you want to count the total number of highlighted words, you must understand that there is no direct way in Word to do this task. But as workarounds, you can choose to pick either one of the following methods in different cases. Method 1: Count All Highlighted Words in...

Read more »

How to Standardize the Texts in Your Spreadsheet with Excel VBA

We’ve all seen spreadsheet names and addresses with a mix of formats like JAMES JONES, sARAH bERNARDT or clint eastwood, all of which look amateurish on a report. This article shows how to standardise text in the proper way in a worksheet. This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. The Excel file can be found here In this exercise we’ll build a...

Read more »