Office Solutions

3 Kinds of Useful Reminders in Word Created via VBA

In this article, we would like to introduce you with 3 different kinds of reminders in Word which you can create via VBA. Since some of us have to deal with a lot of files in Word on daily basis, we are likely to get dizzy with what to do and leave some jobs undone sometimes. In that case, a reminder shall be helpful. Therefore, we present you 3 sorts of handy reminders you can utilize to keep track of what to do. The First Kind: The Daily Reminder For example, if you prefer making plan...

Read more »

How to Convert UTM Coordinates into Latitude and Longitude values via Excel VBA

With UTM converter you can easily convert UTM coordinates into Latitude and Longitude values. A Universal Transverse Mercator (UTM) coordinate is made up of a zone number, an easting, a northing and a hemisphere (N/S). Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI As shown in the image, leave top 4 rows of the excel sheet for...

Read more »

How to Auto Check and Display If the Incoming Emails Are BCC’d to You with Outlook VBA

In order to prevent yourself from replying the emails which are simply BCC’d to you, you must desire that Outlook can auto check and display if the incoming emails are BCC'd to you. This post will teach you how to create a new column for the “BCC” info with Outlook VBA. Actually in my previous article – “How to Auto Mark Each Email BCC’d To You with a Warning Notice in Outlook”, I’ve introduced a workaround that can create a warning for the emails BCC’d to you, like the...

Read more »