Office Solutions

How to Quickly Block & Unblock Attachments with Specific File Types via Outlook VBA

Outlook is set to block the attachments with specific file types, such as “.exe”, “.bat” or “.mdb” file. This article will teach you how to block and unblock specific file types in attachments via Outlook VBA. By default, Outlook is able to auto block the attachments with specific file types like “.exe” or “.bat”, etc. More specifically, for instance, when you try to attach such files to an email, you will get a warning. Plus, if you receive any emails with such...

Read more »

3 Ways to Batch Promote or Demote Heading Levels in Your Word Document

In this article, we would like to expound 3 ways to batch promote or demote heading levels in your Word document. The proper use of headings makes a good structure in a document. And speaking of property, it’s inevitable to change heading levels now and then. For example, while merging several individual documents into one, you will have to promote or demote some heading levels.Admittedly, it’s not rocket science to promote or demote a single heading level at one time. But, when it...

Read more »

How to Quickly Export the Count of Items in Each Color Category in Your Outlook to Excel

If you would like to quickly get the total count of items in each color category in your Outlook PST file, you can use the VBA code exposed in this article. It’ll export all the counts into an Excel file directly for your convenient check. Sometimes, for some reasons, you may want to count how many items are in each color category in an Outlook data file. In general, you can use instant search to do the counting. For instance, firstly click into the search box. Then click “Categorize”...

Read more »