Finding/printing ALL recurring events

[Brian B. Egan]

When visiting clients, I use Outlook to keep track of the
number of miles travelled by using the client name and
miles as the subject line, as in:
HumaneSociety: 22 miles
I set up recurring events for those clients I visit
weekly.

At the end of the year, I want to print out all the
events associated with a given client so I can total the
miles for my tax return. I have been using the Advanced
Find... feature to search on the client name (e.g.,
HumaneSociety), highlight the events for the current
calendar year, and print them.

However, when the events are recurring, only the first
instance shows up. All one-off appointments have their
own lines, but I lose n-1 of the recurring ones, and thus
cannot find my mileage. I have to step through the
calendar and add them up manually.

Is there a way to export all my appointments to Excel as
they appear in the calendar, with one occurrance per line
so that I can sort/total/etc. the data offline?

Thanks,
Brian

 

[Sue Mosher [MVP]]

This can only be done with a custom application (VBA or VB is fine) or
perhaps something like Crystal Reports. There's no built-in way to extract
details from recurring appointments.

 

[Guest]

I am having a similar problem. I have a User who is trying to do a Search on a Calendar on which she is a Delegate. The Find function runs okay, but we know that not all instances are shown. Would this be an SQL or VBS resolve too?

----- Sue Mosher [MVP] wrote: -----

This can only be done with a custom application (VBA or VB is fine) or
perhaps something like Crystal Reports. There's no built-in way to extract
details from recurring appointments.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sue Mosher [MVP-Outlook]]

Find and Advanced Find display their data in a table view, which can show
only master appointments, not individual recurrences. Recurrences display
only in day/week/month views. If you want a search that shows recurrences,
you'd have to build your own UI for the results.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


I am having a similar problem. I have a User who is trying to do a Search
on a Calendar on which she is a Delegate. The Find function runs okay, but
we know that not all instances are shown. Would this be an SQL or VBS
resolve too?

----- Sue Mosher [MVP] wrote: -----

This can only be done with a custom application (VBA or VB is fine) or
perhaps something like Crystal Reports. There's no built-in way to
extract
details from recurring appointments.