8 Ways to Quickly Clear the Formatting of Characters or Paragraphs in Your Word Document

In this article, we will provide you with 8 ways to quickly and easily clear the formatting of characters or paragraphs in your Word document. Now and then, there can be times when you just finishing formatting a document, only to find you have to clear certain formatting of the texts, such as character formatting or paragraph formatting only. Or sometimes you will just have to strip the whole document of its original formatting. In the content below are the solutions to all issues...

Read more »

How to Rename the Attachments When Forwarding an Email in Outlook

Sometimes, when you forward an email that contains several attachments, you may want to rename the attachments directly when forwarding. This article will teach you how to accomplish it with Outlook VBA. By default, Outlook doesn’t permit user to rename attachments when forwarding. Therefore, if you would like to rename them, the unique way is to first save the files to a local folder on your computer, then rename them and next re-attach them to the forwarding email. Obviously this method is...

Read more »

How to Copy the List of All File Names in a Folder into Excel Worksheet via VBA

Collecting all the file names in a worksheet is very important to your work. In this article, we will introduce a method to input all the file names into a worksheet by using VBA macro. In our previous article 2 Methods to Copy the List of All File Names in a Folder into Your Excel Worksheet, we have introduced two methods to list all the file names in a folder into a worksheet. And now we have found another method. You can also use the VBA macro to finish this task. Follow the steps below...

Read more »