Office Solutions

How to Quickly Count Incoming Emails by Date, Month or Year via Outlook VBA

If you would like to count the number of incoming emails on a specific date, or in a specific month or year, you can use the quick means introduced in this article. It will teach you how to use VBA to get it in a flash. When it comes to counting how many emails received in specific date or periods, many are accustomed to using Outlook search folder, which permits us to gather all the emails incoming in the specific date or date range in a single search folder. Then we can use the “show...

Read more »

How to Utilize Conditional Events to Present Data in Different Levels of Details

Spreadsheet rows can trigger context-sensitive events by using the "BeforeDoubleClick" event. In this simple exercise we illustrate how to drill-down from an executive report to the data below. 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 workbook to be used has a number of populated sheets. Please use the one found here for this exercise. The...

Read more »

2 Methods to Create an Appointment Located at the Address of a Contact in Outlook

If you want to create an appointment from a specific contact and use the contact address directly as the appointment location. In this case, you can apply the 2 ways introduced in this article. Sometimes, you may need to schedule an appointment with someone, who is a contact in your Outlook, and use the contact address as the appointment location straightly, business address or home address. For most people, the most familiar method is to manually create an appointment and copy the contact...

Read more »