Scheduling your Drive Time in Outlook
When I posted the simple macro to create an appointment from an email message, I got a message from a colleague, Kurt Shintaku, who came up with an idea for a time-saving Outlook macro when working with one of his customers: create a "Drive Time" appointment immediately before an existing appointment.
I wrote this short macro while waiting for my airplane in the Denver airport and added it to my quick-launch toolbar for appointments (It's the signpost on the far right). Now I'm using Live Writer on the airplane to compose my blog post. Here's what the macro does:
For the selected appointment, create a new appointment with the following properties:
- Subject should be Drive Time for {appointment.Subject}
- Location should be the appointment's location
- Duration should be 30 minutes
- Start time should be 30 minutes before the appointment
- Busy state should be "Out of Office"
- Category should be Yellow "Drive Time"
- Add a reminder of what not to forget.
- Save the new appointment
- Display the new appointment
Give it a try and tell me what you think of it. The macro is attached to this post.
