This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Would someone be able to provide a VB macro that I can execute on demand weekly to generate an Excel spreadsheet showing the total hours per Category per day for a specified date range. The rows would be Categories, the columns would be each day in the date range, and the values would be the total duration of each Category per day.
I'm currently on version 2202 (Build 14931.20806)
If I run this weekly i can save the generated spreadsheet and easily transpose the total hours for each category into our time clock system.
Currently I have to visually look at each day in the calendar and manually add up the total for each category then transpose that into our timeclock system. Very tedious and prone to going cross eyed.
Thank you,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Hi @Duryea, Christopher ,
Welcome to our forum!
Looks like your issue is more related to vba Macro, please kindly understand that the Outlook tag here we mainly focus on general issues about Outlook desktop client. In order to better solve your problem, we will add "office-vba-dev" tag.
Thanks for your understanding and hope your issue would be resolved soon.
lol, I guess I shall keep chasing my tail because I was told to post here from my original post:
Yes that needs not exists as build in solution. You should look around for tool to do that.
I build reporting add-in but focused on email - not calendar meetings.
Mostly, I focus on importing data to the calendar, not exporting content in the form of a report
Maybe that is a good idea to do that - but as usual that is a proces to create it good and work on any version, so I can say that I cant help you ready to use tool for now.