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’s 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 the code will exit without doing anything.