Office Solutions

How to Auto Capitalize Each Word in Subject when Composing Your Outlook Email

When composing a new email and filling the subject, you may hope that Outlook is able to auto capitalize each word in subject line. Though Outlook doesn’t have a native feature, you still can get it by the means shared in this article. Perhaps you are accustomed to always capitalizing each word in mail subject line when composing an email. Yet, you may think that the frequent case shifts are too troublesome. Under this circumstance, it’s much more convenient if Outlook can auto...

Read more »

How to Quickly Get a List of All Outlook PST Files on Your Local Drive via VBA

If you hope to get a list of all the Outlook PST files stored on a local drive of your PC, you can utilize the piece of VBA code shown in this article. It can allow you to get it in quick time. Maybe you have created and stored many Outlook PST files on a partition of your computer. Yet, with time going on, you may forget the concrete location of these PST files. In this case, you may want to quickly find out them and achieve a list of their information, including name, size and path. In...

Read more »

How to Prevent Bad Data from being Saved in Access Tables by Using Validation Rules

In this article we look at why validation rules are so important in keep the data stored in MS Access in pristine shape MS Access allows the users to manage data in the most convenient way but it’s often observed that accuracy remains a challenge for bigger databases and yes we do end up with Bad data. Also known as dirty data; Bad data is any information that is misleading, erroneous and lacks formatting, causing serious damage to the data purpose. The problem comes in picture because of...

Read more »