Automated Reminder Email


A gent named Joni Räsänen contacted me on Twitter with a question/request. Here’s Joni’s tweet.

The solution to Joni’s request is to use Outlook’s built-in appointment reminders to trigger sending the email. To do this, we’ll trap the event that fires each time a reminder goes off. The code will check to see if the item that triggered the reminder is an appointment and if it is a member of a certain category. Checking the category will allow Joni to set reminders on any appointment, including those he doesn’t want an email sent for. If the appointment is a member of the designated category, then the code will create and send a predefined message. If the appointment is not a member of the designated category, then it will exit without doing anything.
Continue reading

2013 in review

The stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 95,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 4 days for that many people to see it.

Click here to see the complete report.

Print An Email Without The Header


Bill, a visitor to this blog, asked if I knew of a way to print an email without printing the header (i.e. From, Sent, To, and Subject) at the top of the message. In Bill’s words

However, it sure seems like there should be some ways out there to print the email body only (with no header) directly from Outlook. Not sure why no one has worked a method for that.

I’m not aware of a built-in way to do this, so I created a way. The macro below prints the current message without the header. It does this by copying the message body into a blank Internet Explorer window, then calling IE’s built-in print command. The output goes to the default printer, so Bill will need to make sure he has the right printer set as default before using this.
Continue reading