Office 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 »

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 »

How to Auto Use a Specific Printer to Print Outlook Emails

You can’t configure Outlook to use a specific non-default printer to print emails. But in this article, we will show you a method to achieve it with Outlook VBA. Your computer must have set a printer as the default one, which will be applied to all programs on this computer. In this case, if you want to print emails through a non-default printer in Outlook, you have to change the printer every time when printing. It is quite troublesome. Therefore, in the followings, we will share you a...

Read more »