For instance, apply a filter based on time period and/or categories. If you have a lot of items in a folder, applying a filter to your view might be helpful too. However, realize that recurring meeting items will only be listed once and thus only counted once in a list view. If you need to select items from a Calendar over a longer period of time, switching to a List view might make the selection process easier. Add a button for easy access to the macro.Īdd a button of the macro to the QAT for quick access to it.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.
#Complete the selected task in outlook 2010 full
Need a full report? While the Excel method in this guide works for most situations, it is quite labor intensive to generate each time.
0 kommentar(er)
