I want to create a daily report of my time by categories. I log my work with appointments that I assign categories to. (The categories are the number assigned to the project for billing.) I want to automate creating a report that will sum the hours I logged for each category used that day. Ideally, it would create a table for each category that lists the each appointment's subject, start time, end time, duration, and notes, with total of time spent for that category and a sum of the time worked that day. Outlook has the data! but how do I extract it for the report? Can this be done with views?? Would I need to use VBA?

I think this would be easy if I were using Access to log all my time and I suppose that may be my solution. However, I don't want to run Outlook, Access, and the several other programs I use all day at the same time. Can Access pull data out of an Outlook database? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>