Office Solutions

How to Auto Create a New Appointment When an Email Is Flagged in Outlook

Some people desire to automatically or quickly create a new Outlook appointment when they flag an email. This article will introduce an approach to realize it with Outlook VBA. Sometimes, I may receive an email which mentions an appointment or meeting. But it is just an email instead of a common meeting item in Outlook. In this case, I have to create a new appointment in my Outlook calendar manually. That’s a bit troublesome. So I wish that Outlook can automatically create a new...

Read more »

Why Network Attached Storage Is an Advisable Data Backup Option?

To put it simply, a network attached storage (NAS) device is a mix of external hard drive and the cloud-based storage. This article will delve into the NAS and tell you 5 reasons why it is a wise data backup option. The previous article “What’s the Best Backup Options for Your Data?” has thrown some light on the Network Attached Storage (NAS) devices. In brief, they are hard drives connected to the network. But unlike the traditional hard drives, Network Attached Storage (NAS) device...

Read more »

2 Effective Methods to Keep Leading Zeros in Cells in Your Excel Worksheet

When you input leading zeros into cells, you will find that Excel will remove zeros from cells. Here we will introduce two methods to keep them in the cells. There are cases that you will input numbers with leading zeros. However, even if you manually input the zero into cells, you cannot see it when you press “Enter”. This will cause trouble to you when those leading zeros have special meanings. In order to help you solve this problem, you can use the two methods below. Method 1: Input...

Read more »