appt exporting filters

[javier.gomez]

Does anybody know how to export appt items from a specific start date?

 

[Vince Averello [MVP-Outlook]]

Copy the appointments to a new folder then export from there.

 

[javier.gomez]

I guess I wasn't specific. I wrote a VB program to export Outlook
AppointmentItems to an Access database, but I only want to export items
with a start date greater than #dtStart# and less than #dtEnd#. I
originally had the program iterate through all appointments and check
the date, and if the date fell within those dates export it. But when
users with years of appointments ran the program, it took far too long.
Any ideas?

 

[Vince Averello [MVP-Outlook]]

Not off the top of my head but I'll check

 

[javier.gomez]

FYI, I figured it out; I used the Restrict method as followed:

strDateRange = "[Start] >= '" & dtStart & "' and [Start] <= '" & dtEnd
& "'"
Set myAppts = myAppts.Restrict(strDateRange )