File Recovery

How to Batch Clear All Color Categories in All Outlook Items

For some purposes, you want to start using color categories from scratch in your Outlook. Therefore, you would like to clear all color categories in all Outlook items. In this article, we will introduce an efficient means to get it. For example, in order to rebuild color categories, you delete all the existing color categories in your Outlook. But, after deletion, you may find that these categories are still attached to the Outlook items. The only change is that the categories lose their...

Read more »

2 Methods to Batch Change Multiple Hyperlinks’ Addresses in Your Outlook Email

For some reasons, you've inserted multiple hyperlinks to texts in your Outlook email. And some of them are linked to the same address. If you would like to batch change these hyperlinks' addresses, you can use the methods introduced in this article. For instance, you have composed an Outlook email, which has a lot of hyperlinks in the message body. Yet, afterwards, you discovered that an address is wrong. And many hyperlinks are using this address. Therefore, you need to batch change these...

Read more »

How to Summarize Data in MS Access using Crosstab Query

Here we learn about the use of Crosstab Queries in MS Access, and how to create them. When you are working on Access databases, and need a summary that looks more like an Excel spreadsheet, you might want to try using the Crosstab Query. Just like an Aggregate Query gives you an aggregate of certain fields, a Crosstab Query can give you a comprehensive summary of certain fields. Plus an Aggregate query can be used when you are looking for one final number, the function of Crosstab query is...

Read more »