Office Solutions

How to Quickly Find the Contacts without a Photo in Your Outlook

Outlook doesn’t provide search filters that can support users to find the contacts that don’t have photo. Thus, if you wish to quickly search out the contacts without a photo, you can use the method shared in this article. Some users would like to quickly find out all the contacts that don’t contain photo. Yet, by default, Outlook doesn’t offer such a native search filter. Hence, you have to create such a filter in the first place. You could use the piece of VBA code below to achieve...

Read more »

How to Quickly Export the Statistics of Appointments in a Specific Period via Outlook VBA

If you want to count the appointments per day in a specific date range and export the results to an Excel file, you can use the smart way introduced in this article. It can accomplish this in quick time. Sometimes, you may need to count the appointments per day. Of course, you can choose to count manually. However, it is still a bit troublesome and error prone if there are too many appointments in your calendar. Hence, you had better search any more effective means, such as the following...

Read more »

How to Use IsVisible and HideDuplicate Properties to Hide Duplicate Fields in MS Access

IsVisible and HideDuplicate property allow the user to hide the duplicate and repetitive fields in Microsoft Access but there is a small difference between the two. The article sums up the functioning of these two properties. MS Access is one of the reliable solution for managing databases in small and midsized firms. A common problem faced by users of Access databases is the unnecessary repetition of records in text fields. It can however be dealt with IsVisible property. The Duplicate...

Read more »