Office Solutions

How to Quickly Find One-sentence Paragraphs in Your Word Document

In this post, we want to exhibit you the quick way to find all one-sentence paragraphs in your Word document via VBA. Now and then, some documents can have very specific requirements for their formatting and structures. For instance, you may not be allowed to have paragraphs with just one sentence. These paragraphs are not hard to recognize, but it takes time, especially it’s a long document. Today, we will offer you the fast way to specify all one-sentence paragraphs in your...

Read more »

2 Useful Methods to Replace Highlight Color in Your Word Document

In this article, we are delighted to show you 2 useful methods to replace the highlight color in your Word document. Sometimes you may highlight different contents with different colors. But unlike font color, you cannot utilize the “Find and Replace” to find texts in a specific highlight color and replace it with another one. Therefore, we are going to need some workarounds. Following are 2 ways available for different cases. Method 1: Replace All Highlight Colors with the Same...

Read more »

How to Auto Archive an Outlook Email when Assigning a Specific Color Category to It

Some users wish that Outlook can auto archive an Outlook item as soon as they assign a specific color category to it, such as “Archive” category. In this post, we will share you a method, which can take Outlook email as an example. By default, you can only make Outlook to auto archive items on basis of the time intervals. However, in reality, many users even would like to auto archive items as per the color categories. For instance, when you apply a specific color category to an email,...

Read more »