3 Quick Methods to Recursively List All Files in a Windows Folder in Excel Worksheet

Many users need to quickly list all files in a Windows folder and all of its subfolders in an Excel worksheet. Therefore, in this article, we will introduce you 3 rapid ways to realize it. If you want to recursively list all files in a Windows folder in an Excel worksheet, you'll surely dislike copying the file names to Excel manually. Undoubtedly, it is too tedious and time-consuming. Hence, here we will teach you 3 much smarter and more convenient approaches Method 1: List Files in a...

Read more »

How to Auto Delete the Outlook Emails from a Specific Sender after Specific Days

To let your Outlook auto delete the emails from a specific sender from specific days, you can read this article. Here we will show you the detailed steps to use VBA code to get it. When it comes to auto deleting emails, you may firstly think of the "AutoArchive" feature. However, it cannot filter the specific senders when auto archiving emails. Therefore, for instance, if you would like to auto delete the emails from a specific sender after x days, you should use the other means, such as the...

Read more »

How to Auto Use Different Font Colors for Replying and Forwarding Emails with Outlook VBA

By default, you cannot let Outlook auto use different font colors for replying and forwarding emails. Therefore, if you have such a requirement, you can read this post to learn a smart approach. Outlook only permits you to specify a font used for both replying and forwarding emails. You can go to "File" > "Options". Then, in "Outlook Options", turn to "Mail" tab and click "Stationery and Fonts…" button. In the subsequent window, you can see the "Font" button in "Replying or forwarding...

Read more »