How to Update an Excel Worksheet Periodically with a VBA Timer

This article shows how to refresh a worksheet or chart at regular intervals. This exercise builds a timer that refreshes the worksheet every one minute, reflecting changes in the source data. This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". An example of the workbook used in this exercise can be found here. Uses of dynamic reporting might be: Reading the...

Read more »

2 Methods to Remove the Original Background Color of an Email When Replying It

When replying an email which has background color, if you would like to remove it, you can use the following 2 means introduced in this article. Some users like to use their preferred background color in their emails. Thus it is believed that you may have ever received such emails which contain customized background color. If you dislike the color, you must wish to remove it when reply the email. As usual, to remove the color, you can manually change the “Page Color” to “No Color”....

Read more »

How to Batch Send Email to All the Contacts in a Specific Domain

At times, you may wish to batch send an email to all the contacts in a specific domain. In this case, you can use the method introduced in this article to quickly get it. For some reasons, sometimes, you may need to send an email to all the contacts in a specific domain in your Outlook. For instance, you are required to send an email to all of your colleagues whose email addresses are certainly in a specific email domain. It will be quite troublesome if you manually find out these contacts....

Read more »