J
javier.gomez
Does anybody know how to export appt items from a specific start date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Vince Averello [MVP-Outlook]
Copy the appointments to a new folder then export from there.
J
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?
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?
V
Vince Averello [MVP-Outlook]
Not off the top of my head but I'll check
J
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 )
strDateRange = "[Start] >= '" & dtStart & "' and [Start] <= '" & dtEnd
& "'"
Set myAppts = myAppts.Restrict(strDateRange )