How to Let Outlook Ask Whether to Save a Copy When Sending Emails

When resending or forwarding an email, you may want not to save a copy in your Sent Items folder. This article will teach you how to configure Outlook to prompt for saving a copy or not with Outlook VBA. In reality, for most common emails, you must prefer to save their copies in your Sent Items folder. Nevertheless, in some situations, such as when you resending, forwarding an email or when this email carries a very large attachment, you may think it unnecessary to keep a copy. Under these...

Read more »

How to Create a Calendar in Your Excel Worksheet with VBA Script

Excel has a wide range of usage. In this article, we will show you how to create a calendar in a worksheet by using a macro. Except for storing and analyzing data in your Excel, you can also use it to finish other tasks. For example, you can collect information by using Excel, or you can note down your planning in the worksheet. Today we have found a new usage. You are able to create a calendar in a worksheet. You can see the effect in the image below. You can input some tasks into this...

Read more »

2 Methods to Find and Select Cells with the Same Format in Your Excel Worksheet

In your Excel worksheet, you will format cells that meet certain criteria. When you need to select cells, you will spend a lot of time. Here we will introduce two effective methods for you to find and select those cells. Sometimes you need to select cells with the same format and then finish some tasks. For example, you need to change the format or delete the format for those cells. However, in most cases, those cells will be separated in different places. Therefore, you will find it hard to...

Read more »