Office Solutions

DataNumen Debt Manager – A Free Debt Management System in Your Excel

If you are paying a lot of loans and bills, this article is very important for you, as you will learn how to track all your bill payments in your Excel easily. You can set reminders, upcoming payments without difficulty. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI As shown in the image, prepare the Entry and Database sheet with...

Read more »

How to Batch Find & Replace Specific Words in All Outlook Folder Names

At times, you may batch rename multiple Outlook folders by finding and replacing specific words in their names. This article will teach you how to quickly accomplish it by using Outlook VBA. To better organize your emails, you must have created a lot of custom folders in your Outlook. Faced with so many customized folders, at times, for some reasons, such as superior’s requirements or your changing preferences, you may want to rename these folders. Most of time, perhaps you simply would...

Read more »

How to Unzip the .Zip Attachments Directly in Outlook via VBA

When you receive an attachment in “.zip” file extension, if you want to unzip them, in general, you should save and unzip them in local drive. But many hope to unzip them directly in Outlook. This article will teach you how to get it via VBA. You must have ever received the attachments which are in “.zip” file extension. In order to access the internal files in one zip file, you have to firstly unzip it. In this case, as usual, you have to first save the zip file to local drive and...

Read more »