![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Does anybody know how to export appt items from a specific start date?
|
Ads |
#2
|
|||
|
|||
![]()
Copy the appointments to a new folder then export from there.
wrote in message oups.com... Does anybody know how to export appt items from a specific start date? |
#3
|
|||
|
|||
![]()
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? |
#4
|
|||
|
|||
![]()
Not off the top of my head but I'll check
wrote in message oups.com... 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? |
#5
|
|||
|
|||
![]()
FYI, I figured it out; I used the Restrict method as followed:
strDateRange = "[Start] = '" & dtStart & "' and [Start] = '" & dtEnd & "'" Set myAppts = myAppts.Restrict(strDateRange ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Set default appt duration to 0? | R. Barre | Outlook - Calandaring | 1 | February 9th 06 07:51 PM |
Task filters should be linked to calendar filters | fetch98 | Outlook - Calandaring | 0 | January 19th 06 09:06 PM |
Custom View Filters - Advanced | deandepetra | Outlook - Using Contacts | 1 | January 18th 06 11:15 AM |
Cannot change appt after migration to 2003 | spanky | Outlook - Calandaring | 2 | January 17th 06 06:35 PM |
Customise View Filters | deandepetra | Outlook - Using Contacts | 0 | January 17th 06 03:16 AM |