Sign your code so you won’t get any security prompts and the macro won’t get disabled.Optionally set the ShowMileage variable to True to also report the total mileage recorded for the selected items.If you copied the code paste it into a new module. Extract the zip-file and import the TimeSpent.bas file via File-> Import….Open the VBA Editor (keyboard shortcut ALT+F11).Download this code-file ( timespent.zip) or copy the code below.Optionally you can get the total mileage result as well. Just select your items and execute the macro to see the results.įor Tasks, the total work time is also reported. Optionally, you can also let it calculate the sum of the recorded mileage for these items. These selected items can be Calendar, Task and Journal items of your choice. The TimeSpent macro allows you to calculate the total amount of time spent on the selected items. The reporting templates can be adjusted to match your company’s standard layout and formatting and include the company’s logo.

If you need to create reports from Outlook data on a regular basis, using VBOffice Reporter would be a more elegant approach and reports can be pre-configured and generated in an instant. Need a full report? While the Excel method in this guide works for most situations, it is quite labor intensive to generate each time.

Show tasks in outlook calendar