Office Solutions

How to Quickly Export the Count of Emails from Each Contact in Your Outlook to Excel

If you want to get the most active contacts, you need to count how many emails you have received from each contact. This article will expose a piece of VBA code, which will do the counting for you in quick time. At times, you may want to get who are the most active contacts in your Outlook. In other words, you would like to figure out who frequently contact you. In such a case, you have to count how many mails sent from each contacts in your Outlook. Without any doubts, manually counting is...

Read more »

How to Open & Access Different Outlook Areas in Different Windows at the Same Time via VBA

If you want to access Mail, Tasks, Calendar and Contacts areas in different Outlook windows at the same time, you can use the method introduced in this article. It will show new area in new window when switching. By default, when you switch to another area, the selected target area will be open in the current window. However, many users would like to view different Outlook areas in different windows at the same time. In general, you can click the “Open in New Window” button under...

Read more »

How to Get Warned When New Task Has the Same Subject as an Existing One in Outlook

In order to prevent cluttering up your task list, many users tend to utilize different subject for different tasks. In this article, we will expose a piece of VBA code which can let Outlook warn you when new task has same subject as an existing ones. If you have many tasks which have the same subjects, not only will you find it a bit difficult to distinguish them in the Outlook task list, but also there may be some duplicate ones among them. Therefore, it is suggested not to use the same...

Read more »