3 Easy Tricks to Exclude Specific Outlook Items from Being Auto Archived

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 »

How to Auto Remove the Prefix “RE” or “FW” in Subject when Replying or Forwarding Emails

When you try to reply or forward emails via hitting “Reply”, “Reply All” or “Forward” button, there must be “RE” or “FW” prefix added in the front of the email subject. This article will tell you how to let Outlook auto remove them with VBA. In our pervious article – “2 Methods to Forward Outlook Emails without “FW” Prefix in Subject”, you can get two workarounds to forward emails without “FW”. They are resending the emails and creating a “Forward” quick step respectively. It is obvious that...

Read more »

2 Methods to Auto Update the Reference Range of a Defined Name in Excel Worksheet

Using defined name in Excel can save you a lot of time. Here we will introduce two methods to automatically update the reference range of a defined name in the worksheet. A defined name has a wide range of use. You can even use a certain name in formulas. The defined named can help you increase your work pace. Sometimes you will certainly add new items into the source range of this name. However, the reference range in the name will not update automatically. In order to solve this problem,...

Read more »