Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / September 2006

Tip: Looking for answers? Try searching our database.

Finding Recurring Items with Exceptions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tadwick - 15 Sep 2006 00:35 GMT
Could someone please confirm the following.  If you want to find all
appointments between two dates StartRange and EndRange you can restrict the
items collection using a filter as in :

strFilter = "([End] > '" + Format(StartRange, "mmmm dd, yyyy") + " ' AND
[Start] < '" + Format(EndRange, "mmmm dd, yyyy") + "') "
Set oItms = oItms.Restrict(strFilter)

However, to be rigorous you need to find all exceptions that fall inside
your range.  The problem is that you cannot rely on the above filter to
capture those exceptions as the recurrence pattern may specify dates outside
the range but one or more exceptions may be inside the range.

So the solution seems to be either set IncludeRecurrences to True and take a
performance hit or get the recurrence pattern for all items and check all the
exceptions for dates in the range.

Is this correct?

Thanks, Tad
Michael Bauer [MVP - Outlook] - 15 Sep 2006 05:29 GMT
Am Thu, 14 Sep 2006 16:35:02 -0700 schrieb Tadwick:

Yes, for getting recurrences with Restrict you need to set
IncludeRecurrences=True.

Signature

Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
 -- www.VBOffice.net --

> Could someone please confirm the following.  If you want to find all
> appointments between two dates StartRange and EndRange you can restrict the
[quoted text clipped - 16 lines]
>
> Thanks, Tad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.