Office Solutions

How to Quickly Copy Folder Structure from One Outlook PST File to Another via VBA

If you want to copy the folder structure from one Outlook PST file to another, you can use the method introduced in this article, which will teach you how to use VBA to get it in one go. Perhaps, in order to better manage your emails, you have created several custom folders in your main Outlook file. Thus when creating a new Outlook PST file, you may want to apply the same folder structure. Actually, in my previous article – “2 Steps to Keep the Current Folder Hierarchy in a New Outlook...

Read more »

How to Easily Manage, Track and Split the Tasks of Your Project in Excel

If you are a project manager, this article will help you to easily plan and track tasks in your project and instantly assign a task to your employees. Split the master file and share it with each employee. 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 For this tool, we need a macro enabled workbook with 2 sheets. Rename sheet1 as...

Read more »

How to Batch Import All vCards in a Local Drive into Outlook via VBA

By default, Outlook doesn’t have a feature supporting you to import multiple vcards in batches. Fortunately, you can use VBA to achieve it. This article will teach you how to use VBA to bulk import all the vcards from a local disk into Outlook. If you have a lot of contacts stored in vCard format in one of your computer local drives, so as to make use of these contacts effectively and flexibly in your Outlook, you may want to import these contacts into your Outlook. Nevertheless, you will...

Read more »