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...

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

"Charlie" <(E-Mail Removed)> wrote in message
news:56413FF7-53F7-4AD1-A467-(E-Mail Removed)...
> 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...

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.

--
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...