Office Solutions

How to Import and Manage Multiple Excel files from a Master File in Excel

Being a manager is really a tough job. Managing your employees, collating their work, preparing a report and sending it to the senior management really needs a lot of time. With Excel and macro build a tool which will quickly merge all your employee's workbook into one workbook. You can then share it with your senior management 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...

Read more »

How to Get a Warning When Sending Emails to the Persons outside Your Company

If your company has an exact policy that you shouldn’t send emails to the persons outside your company, you can use the way introduced in this article. It’ll teach you how to use VBA to get a warning if an email is sent to outside your company. Sometimes, in order to protect data security, your company may demand you that when using business email account, you should only send emails to the persons inside your company. In other words, you aren’t permitted to send emails to the persons...

Read more »

How to Quickly Remove the Duplicate Outlook Items in a Folder via VBA

If you wish to remove the duplicate items in Outlook, searching and removing one by one will be quite troublesome. This post will teach you how to quickly complete it with Outlook VBA. In my previous article – “How to Quickly Find and Remove Duplicate Emails in Outlook”, you can learn a trick to find and remove duplicate emails, which firstly sort the emails by subject, then by received time and then by attachments to find out the duplicate items and lastly select the duplicate ones...

Read more »