How to Keep an Email Open after Marking It Complete in Your Outlook

By default, in Outlook, after you mark a flagged email complete in its open Message window, the email will be closed automatically. This article will teach you how to keep an email open even after you mark it complete. Perhaps you have noticed that Outlook will automatically close the opened email after you mark it complete. Yet, most of time, you still want to continue dealing with this email, such as moving it to another folder and so on. If it is closed, you have to spend some time...

Read more »

How to Auto Categorize New Emails Based on the Categories of Old Emails with Same Subject in Outlook

When a new email arrives in your mailbox, if you want to quickly find out the old emails with same subject and apply the color categories of the found emails to this new email, you can use the piece of VBA code shared in this article. So as to better classify and manage a great number of emails, you may be used to color categorizing emails. In this case, you must hope that Outlook can auto color categorize incoming emails based on your desired criteria, such as categorizing new email on...

Read more »

What to Do If Your SQL Server Database Misses Key

If your database is missing a master key, service broker will try to access it and will throw errors in SQL Server Error log. In this article, lets learn how to verify keys in your database and how to install keys if they are missing. Entry in SQL Server Error log: If your SQL Server error log has entries as mentioned below, then the target database is missing its master key. Service Broker needs to access the master key in the database '%.*ls'. Error code:%d. The master key has to...

Read more »