Solutions

How to Use Aggregate Queries in MS Access

This article explains salient aspects about Aggregate queries in MS Access, what are the operations is offers, and how to make use of them. In MS Access you might want to perform calculations on not just a single record, but a group of records. You can always create fields that perform calculations row by row or on each record, but what happens when you wish to perform calculations on a group of records? This is where Aggregate queries come into picture. These queries allow you to calculate...

Read more »

How to Quickly Merge & Export Multiple Excel Workbook Attachments into One Workbook in Outlook

When you receive an email attached with multiple Excel workbooks, if you want to check the contents of all the workbooks in a single workbook, you can use the way in this article. It’ll export multiple Excel workbook attachments to one workbook. To view all the Excel workbook attachments of an email in one Excel workbook, you should firstly combine and export these attachments into a single workbook. Instead of manually doing that, you can use the following method to achieve that with...

Read more »

How to Quickly Export the Business Cards of Outlook Contacts into an Excel Worksheet

If you are keeping an Excel file which contains a list of contacts’ names and now you want to quickly import the corresponding business cards of outlook contacts into it, you can use the method introduced in this article. Outlook allows users to export contact list. Yet, it can only export the information, unable to export the photos or business card images. Thus, if you have exported the contacts to an Excel worksheet and also wish to export the corresponding contacts’ business cards,...

Read more »