Office Solutions

How to Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email

If you want to quickly convert an Excel worksheet to a PDF file and then attach this PDF file to an Outlook email to send it, you can utilize the method introduced in this article. It is using VBA to accomplish this task within seconds. To be honest, to attach an entire Excel workbook as a PDF attachment in an email is pretty easy. You can first save the workbook as a PDF file and then create a new Outlook email and attach the PDF file to this mail. However, in Excel, there is no such a...

Read more »

How to Auto Highlight All Occurrences of Specific Words for Each Incoming Email in Outlook

Some users want to let Outlook search each incoming email for all occurrences of specific words and then highlight them automatically. Though Outlook doesn’t offer such a native function, it still can be realized via the VBA code exposed in this post. In order to quickly figure out the important text in long and tedious emails, many users would like to make the specific words highlighted automatically. That is to say, Outlook should auto search every incoming email and highlight the...

Read more »

How to Auto Update All Fields before Closing Your Word Document

In this article, we shall focus on expounding the way to auto update all fields in a document before you closing it. We use fields to hold data that may change later. So once we make some change to them, we need to update fields correspondingly. And unfortunately, most of time, we will have to update them manually. Besides, the biggest problem lies at we can easily forget to update fields. To address this issue, we offer you a macro to auto update fields before closing document. Update...

Read more »