You appear to be using ad blocking software. While I respect your right to do so, please be aware
that the minimal advertising on this site helps defray the cost of providing this facility, and I would therefore ask that you turn off
the blocker while browsing this site.
Many people access the material from this web site daily.
Most just take what they want and run. That's OK, provided they
are not selling on the material as their own; however if your
productivity gains from the material you have used, a donation
from the money you have saved would help to ensure the continued
availability of this resource. Click the appropriate button
above to access PayPal.
Outlook Appointment Travel Times
Unfortunately the Google has changed the licensing of the API
that was used to calculate the travelling time and so that the
calculation code no longer works. I have left the page as the
code can still add times to appointments that are entered
manually - even though this is now less useful than hitherto.
Outlook makes no provision for travel time when logging meetings
or other appointments. This has been something of an irritation to
me when logging appointments, where the travel time often far exceeds the
appointment time, so when someone raised the issue in a forum
recently, I thought it might be worth creating a function to add
travel time to appointments.
Outlook doesn't lend itself to using add-in templates, like
Word or Excel, so I have simply made the code available as a
pair of modules to download, extract from the zip file and
import into Outlook's VBA editor.
I'm afraid you will have to add the macro to a button on the
context sensitive Calendar Tools ribbon, but Outlook has its own ribbon
editor which makes this fairly straightforward.
It should be easy enough to match the name and icon of the added
macro command to match the following:
Link the button to the macro 'AddTravelToMeeting' and you
should get a button group on the Calendar Tools ribbon as above.
Enter the appointment first and with the cursor in the
appointment in the calendar view, click the ribbon button.
The macro pops up a userform that is used to calculater the number
of minutes of travel time (each direction). The 'home' address
is retained between uses (but can be changed) and the
destination address is read from the appointment location.
If both addresses exist, the process will calculate the time
to travel between them, in minutes, which is then rounded up to
the nearest 10 minute interval. The calculation employs Google
Maps so requires an internet connection. Both outward and return
travel times are initially the same. You can change either or
both manually to add or reduce the travel time to suit local
The travel time assumes road travel with a motor vehicle.
International travel by air is not accounted for as it is
difficult to accommodate flight times into the travel planning.
For such use enter the travel times manually, and do not click
the recalculate button.
The result in the calendar is as shown below.
The project userform does not include my usual disclaimer, but the conditions below apply to its use, so please read the following before downloading the modules.
The processes and features in the modules featured on this
page were developed and provided by Graham Mayor as a courtesy
to the Microsoft Outlook user community from code that is in the
While exhaustive testing has been performed to ensure that
each process is performed reliably and without risk to the
Outlook structure or data, the developer makes no
representations or warranties of any kind, express or implied,
about the completeness, accuracy, reliability, suitability or
availability with respect to the modules or any of the processes
that it is intended to perform. Any reliance you place on the
modules or individual processes is therefore strictly at your
In no event will the developer be liable for any loss or
damage including without limitation, indirect or consequential
loss or damage, or any loss or damage whatsoever arising from
loss of data or profits arising out of, or in connection with,
the use of the modules.
The developer is committed to reasonable effort to address
user comments, suggestions for improvement and technical
assistance associated with the modules. However, the developer
is not bound in any way to address those comments, suggestions
for improvement, or provide technical assistance.