The sequence numbers can always be seen in an Excel worksheet. In this article, we will show you how to auto update the sequence numbers when you insert or delete rows in a range.
You will certainly have used the sequence numbers in a worksheet. With those numbers, the range will be clearer and you can manage your data and information better. When you insert a new row or delete a row in the range, the sequence numbers will be discontinuous.
And you need to update the numbers. It will be...
Read more »
When sending a too large email, you will find it difficult to send it out successfully. So why not make Outlook to automatically check the mail size before sending? This article will teach you how to realize it with Outlook VBA.
As usual, when you intend to attach a file larger than a specific size, you’ll get an Outlook alert, which will stop you from attaching it. MS Outlook comes endowed with this feature, aimed to ensure that the email can be sent out successfully. But if the email is...
Read more »
When configuring Outlook to auto archive items, you may hope to not include specific items in that they are vitally important and frequently required. This article will introduce 3 simple tips.
As we all know, Outlook file is vulnerable if it gets oversized. Fortunately, Outlook comes packed with many cleanup tools, including “Archive” feature. Therefore, it’s advisable to regularly archive old items or just set Outlook to auto archive.
Sometimes, you may want to ignore specific...
Read more »
