Sometimes in a column, the cells will contains both numbers and texts. Here we will provide two methods to sort a column with numbers and texts.
Sometimes there will be numbers and texts in the same cells in a column. If you need to sort this column, you will meet with problems. The order of the column will not be “1,2,3,4,5..”, but it will be “1,10,11,12,…2,21,22…”. Therefore, this kind of order will make your worksheet in a mess. In order to solve such a problem and sort the column with...
Read more »
If you’re using Outlook rule to auto reply, you will discover that the auto reply can’t include the original message in the body. This article will introduce an easy method, which can insert the original email and predefined text to the body of auto reply via Outlook VBA.
In Outlook, the Exchange accounts permit users to set automatic replies directly via “Automatic Replies” button under “Info” tab in “File” menu, like the following screenshot:
But if you’re using the Internet Email...
Read more »
Many users desire that Outlook can automatically assign a specific task to specific people at a scheduled time, like the “Delay Delivery” feature for emails. This article will introduce how to make it realized via Outlook VBA.
As we all know, Outlook permits us to send emails at a scheduled time by means of “Delay Delivery” feature, like the following screenshot:
However, this feature is only available for emails, not for meetings or tasks. Thus, many people are looking forward to a...
Read more »
