Report of annual recurring appintments for this year?

[Guest]

How do I generate a report of this years recurring annual appointments?

We'd like to generate a report listing the current years recurring
appointments filtered by category but the appointment date doesn't appear to
be a choice when selecting search criteria. However if you export calendar
data using a date range a field called "StartDate" is exported.

Is there a way around this, tips, tricks, advice?

TIA

 

[Guest]

The calendar export looks like this:

StartDate Categories
==================================
2/5/2007 Renewal-Internet Security
3/1/2007 Renewal-Internet Security
3/2/2007 Renewal-Domain Hosting
3/8/2007 Renewal-Domain Hosting
5/1/2007 Renewal-Internet Security
5/16/2007 Renewal-Internet Security
5/17/2007 Renewal-Internet Security
5/30/2007 Renewal-Internet Security
8/31/2007 Renewal-Internet Security
9/3/2007 Renewal-Service Contract
9/20/2007 Renewal-Internet Security
10/1/2007 Renewal-Internet Security
10/14/2007 Renewal-Internet Security
10/16/2007 Renewal-Internet Security
10/25/2007 Renewal-Internet Security
10/25/2007 Renewal-Internet Security
11/1/2007 Renewal-Domain Hosting
11/11/2007 Renewal-Internet Security
11/15/2007 Renewal-Remote Access
11/27/2007 Renewal-Internet Security
12/1/2007 Renewal-Internet Security
12/1/2007 Renewal-Service Contract
12/20/2007 Renewal-Internet Security

 

[Karin]

How do I generate a report of this years recurring annual appointments?

We'd like to generate a report listing the current years recurring
appointments filtered by category but the appointment date doesn't appear to
be a choice when selecting search criteria. However if you export calendar
data using a date range a field called "StartDate" is exported.

Is there a way around this, tips, tricks, advice?

TIA

I'm off to a meeting, but can get you started with one idea. Go to
View|Arrange By|Current View|Category. This displays the calendar
items in a list view and then you can sort the column headers. There
is a recurrence field you can sort. I don't use categories, so this
is as far as I got. Hope it helps.

Karin

 

[Diane Poremsky]

use a custom view to show the recurring appointments then copy and paste the
list into your report.
this page shows the basic filtering necessary:
http://www.outlook-tips.net/howto/birthday.htm

 

[Guest]

Thanks to all who replied however this solution does not provide a means to
sort a custom view chronologically. When using custom views, where is the
<appointment_date> field?

When exporting calendar data by date range the "StartDate" field is exported
which identifies the appointment date within the date range specified however
this field does not exist and therefor can not be used to sort by in any
custom view.

My guess is that exporting the data is my only choice.

TIA

 

[Brian Tillman]

Thanks to all who replied however this solution does not provide a
means to sort a custom view chronologically. When using custom views,
where is the <appointment_date> field?

When exporting calendar data by date range the "StartDate" field is
exported which identifies the appointment date within the date range
specified however this field does not exist and therefor can not be
used to sort by in any custom view.

I think you are correct that exporting is your only choice. Recurring
events are single items in the calendar, not multiple ones. Only the first
entry is reall there. The rest are calculated on the fly in the
Day/Week/Month views.