How di I generate a report of appointments by category?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charlie - 26 Sep 2007 19:44 GMT

I'm trying to generate a periodid report that counts the number of
appointments, by category, for a specified range of dates. Ideally, I'd like
to export it to excel to be able to run pivot table analysis on it...

Reply to this Message

Judy Gleeson (MVP Outlook) - 27 Sep 2007 09:41 GMT

The first step is to Define a New View.

Turn on the Advanced Toolbar (leave it on)
Change to a table view (eg By Category) so you can see what you are trying
to do. You use the Current View window to do this . It's in the toolbar you
just turned on.
On the Current View window use the Define New View button to make a view.
Filter it as desired (eg must by Category = yyyy)
Apply the view.
Then select all and drag to Excel.

I hope this helps! (and don't ask me any Excel questions OK?)

Judy Gleeson
MVP Outlook
Trainer and Consultant

read my articles here: www.judygleeson.com
Canberra, Australia

how to post questions: http://support.microsoft.com/?id=555375

> I'm trying to generate a periodid report that counts the number of
> appointments, by category, for a specified range of dates. Ideally, I'd
> like
> to export it to excel to be able to run pivot table analysis on it...

Reply to this Message

Michael Bauer [MVP - Outlook] - 27 May 2008 21:30 GMT

Charly, VBOffice Reporter does exactly that; you may create and export the
report to Excel with just a single click. For details see the link in my
signature, please.

Signature

Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>

Am Wed, 26 Sep 2007 11:44:01 -0700 schrieb Charlie:

> I'm trying to generate a periodid report that counts the number of
> appointments, by category, for a specified range of dates. Ideally, I'd like
> to export it to excel to be able to run pivot table analysis on it...

Reply to this Message