Solutions

How to Batch Disable All Custom Conditional Formatting Rules in Your Outlook

In Outlook, you can create various custom conditional formatting rules to change the display font and color of the items. If one day you desire to batch disable all of such custom rules, you can use the method introduced in this article. Conditional formatting feature allows users to use different fonts and colors to highlight the emails based on their custom criteria. It is pretty convenient. But if afterwards, for some reasons, like resetting the view, you may hope to disable all these...

Read more »

Message Handling Can Affect Your Availability Group Replicas in SQL Server

The state of databases participating in Always On are prone to change due to message handling. A sudden failover might interrupt a large transaction happening in the database that participates in Always On. This will result in a lengthy undo process and database status would be ‘Not Synchronizing’. Error message but no user action needed If your availability group is having hundreds of databases and heavy workload runs on the availability group, a sudden failover will change the status of...

Read more »

How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails

If you would like to send all worksheets in an Excel workbook as separate Outlook emails, you can use the method introduced in this article. It can guide you to realize it in bulk without troublesomely sending one by one. In my previous post “2 Quick Methods to Send an Excel Worksheet as an Outlook Email”, you can learn two ways to send one Excel worksheet as email. If you wish to batch send all worksheets in one workbook as individual emails, using either of the two means mentioned in...

Read more »