Office Solutions

8 Ways to Set Different Background Colors for Header, Footer, and Main Document in Word

In this article, we plan to provide you 8 ways to set different background colors for header, footer, and main document in Word. By default, to set a page color will make all parts of the document in the same background color, including the header, footer and main document. What if we want to set different background colors for these 3 parts? To achieve so, we will have to deploy some workarounds, such as follows: Method 1: Insert a Shape into Header or Footer Let’s take the example...

Read more »

How to Auto Replace a Specific Recipient with Another When Using “Reply All” in Outlook

For some reasons, you may always need to replace a specific recipient with another when using “Reply All”. In this case, you must hope that Outlook can auto do this task. Thus, in this article, we will teach you how to use VBA to realize it. In order to protect someone’s privacy or for some other reasons, you may need to change a specific recipient to another when using “Reply All”. With no doubt, if you’re frequently required to do it, you may long for a more effective way which...

Read more »

How to Quickly Compress All Attachments into a Zip File in Your Outlook Email

Sometimes, you may want to compress all the attachments in an email into a zip file directly in Outlook. In this case, you can use the VBA code introduced in this article to achieve this feature. By default, Outlook has its attachment size limit – 20 MB for POP3, IMAP or other web-based email accounts and 10 MB for Exchange accounts. So, when the total size of attachments exceeds the limit, you will get related errors. In this case, it is a good option to compress all the attachments into...

Read more »