Office Solutions

How to Batch Find and Replace Text in Multiple Outlook Emails

By default, Outlook doesn't support you to find and replace text in multiple emails at the same time. Therefore, if you want to do it, you can refer to this article. Here we will teach you how to realize it via VBA code. For example, you have finished several emails in Outlook. Before you send them out, you discover some mistakes and want to modify some texts in these emails. In general, you have to perform 'Find and Replace" in each email one by one. Yet, it's too cumbersome. Thus here...

Read more »

How to Auto Apply a Specific Stationery when Sending Emails to a Specific Person in Outlook

If you always need to change email stationery to a specific one when sending emails to a certain person, why not configure Outlook to auto do this? This post will guide you to achieve this feature via VBA. Outlook allows you to set specific stationery as the default one for all new html emails. However, at times, you may want to apply another when sending emails to a specific person. For instance, to send emails to your boss, you had better use more official stationery. In this situation, it...

Read more »

3 Different Ways to Compact MS Access Database

In this article, we have addressed three different ways using which users can compact their MS Access Database, and what are their possible pros and challenges. In this article, we will discuss three different ways of compacting MS Access Database. Compact on Close Compacting Current Database in UI Compacting another Database in UI 1. Compact on Close Steps: Open File > Select Options > Open Current Database > Select Compact On Close (checkbox) This option is...

Read more »