Office Solutions

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 »

Understand Domain Aggregate Functions in MS Access and Explore Their Practical Applications

In this article we dig deep into Domain Aggregate Functions of MS Access and check how they can be used in real life scenarios. Functions which are exclusive to MS Access are called Domain Aggregate Functions, these are exclusive because they help in retrieving data from Access tables. One of the greatest advantage of using these functions is the ease and versatility they come with. Almost any practical criteria for retrieving data from tables can be applied to these functions, and they...

Read more »