How to Auto Create a Task whenever a Specific Category Is Assigned to an Email in Outlook

This article will teach you how to automatically create a new task when you assign a specific color category to an email by means of Outlook VBA. In the past, when I received an email involved with a task, I used to specify the “Task” category to this email and proceed to create a new related task. To be honest, this process is indeed time-consuming. I have to write down all the info in advance, since that these details must be demanded in the new task. But now, with the help of VBA, Outlook...

Read more »

3 Effective Methods to Remove Spaces in Your Excel Cells

When you import contents into Excel from other sources, there will be additional spaces in Excel cells. In this article, we will introduce 3 effective methods to remove spaces in cells. Removing spaces in cells can be annoying because it is difficult to find the exact position. And removing those additional spaces will cause a bunch of time and energy. The image below shows the contents that we have copied from other sources. You will find that there are many additional spaces in this...

Read more »

6 Ways to Resolve the Issue when Unable to Input Anything into Word Table Cells

In this article, there are 6 ways available for you to resolve the issue of unable to input in Word table cells. There are situations when we receive a Word document from others, but only to find that we are unable to enter either text or data into Word tables. This can be annoying, but not unfixable. In the following content, we list 6 different methods to deal with this problem along with some causes to it. Situation 1: Unable to Type Only in Certain Cell The first situation might be...

Read more »