How to Change the Email Display Name Formats of All Your Contacts in Batches with Outlook VBA

Outlook will show all the contact emails in its default display name format, namely “full name (email address)”. If you dislike it, you’ll need to change it manually every time when creating new contacts. This article will teach you a quick way to change them in batches with Outlook VBA. When you create a new Outlook contact, after you input the full name and email address and then click into the “Display as” box, the default display name will be filled in automatically, shown as the...

Read more »

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 »