Office Solutions

6 Ways to Keep the Original Email Attachments when Replying in Outlook

Many users hope to configure their Outlook to keep the original email attachments when replying an email. This article will expose 5 workarounds as well as a smart way, which is using VBA to realize it automatically. I have heard a great number of users complaining that Outlook has no a native feature to keep original attachments when replying an email. Therefore, here we will share you 6 methods, one of which is pretty useful as it is using VBA to make Outlook to auto attach the original...

Read more »

How to Export the Folder Structure of Your Outlook File to Excel

If you would like to quickly export the folder structure of your Outlook data file to an Excel workbook, you can utilize the method introduced in this article. For some reasons, such as logging current Outlook folders and subfolders, many users hope to export the folder structure of an Outlook file to an external file, like an Excel workbook. In the followings, we will share you a piece of VBA code, which can help you achieve it in a jiffy. Export the Folder Structure of Your Outlook...

Read more »

How to Display Progress on the Status Bar of Your Excel

Not knowing how long a program will run makes us restless. The program might have hung, or might finish in five minutes – or maybe in two hours. This article looks at keeping the anxious user informed in real-time via the Status Bar. 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”. The exercise will look like this, using the example file found here. The...

Read more »