In theory yes, but that depends, of course, on your VBA skills. There are some links to Outlook export code at http://www.outlookcode.com/article.aspx?ID=23 that should get you on the right track.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Jason R. Senior" wrote in message ...
Could I write a Macro within Outlook which at the click of the button could
generate a simple report for me?

"Sue Mosher [MVP-Outlook]" wrote:

The alternative is to export to Excel and run a pivot table. Outlook can't do math like that in views.

"Jason R. Senior" Jason R. wrote in message ...
I have a simple view which has two columns. Subject and duration. I am
grouping on Subject. What I am trying to accomplish is this: I want total
hours worked on each Subject. My subjects are project numbers, such as
P-12345 and P-45678. I want the view to show P-12345 | 10 hours. Inside
that ten hours may be 5 different appointments, all with the Subject P-12345.
My view does properly group appointments by Subject, but surprisingly I see
no option in Outlook to total on a numeric field, such as duration. This
means I have to manually add up all the individual durations to get a total
duration.

Does anybody have any ideas short of exporting my calendar information into
Access?