![]() |
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
|
|||
|
|||
![]()
I have a large number (600+) of appointments that have become mislabeled as
weekly recurring appointments. Their start times are all correct, and their end times are mostly one day later (all day appointments); all of them are in the past. Unfortunately, now all of these appointments appear as current events (NoEndDate). I tried using the following code to remove the recurrences, and preserve the start date and times, but it seems to do nothing (although the code inside the inner if-then loop is activated 600+ times). What am I missing? ************************************************** ******** Sub FixWeeklyAllDayAppointments() Dim lngNumShiftedAppointments As Long Dim datPatternStartDate As Date Dim mapiAppointments As MAPIFolder Dim itmAppointment As AppointmentItem lngNumShiftedAppointments = 0 Set mapiAppointments = Outlook.Application. _ GetNamespace("MAPI").GetDefaultFolder(olFolderCale ndar) For Each itmAppointment In mapiAppointments.Items With itmAppointment If (.AllDayEvent = False) Then If (Format(.GetRecurrencePattern.StartTime, "HH:MM") = "00:00") _ And (.GetRecurrencePattern.RecurrenceType = olRecursWeekly) Then ' These particular events have been buggered. .ClearRecurrencePattern .RecurrenceState .Save lngNumShiftedAppointments = lngNumShiftedAppointments + 1 End If End If End With Next Set mapiAppointments = Nothing Set itmAppointment = Nothing MsgBox lngNumShiftedAppointments " bad Appointments were found & corrected." Exit Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
recurrence | da-obrienarch | Outlook - Calandaring | 1 | September 28th 07 04:55 PM |
Trying to set a recurrence | Gail | Outlook - Calandaring | 1 | September 19th 07 08:14 AM |
Remove Recurrence is gray out - how do I stop Recurrence? | Marty | Outlook - Calandaring | 1 | April 27th 07 01:24 PM |
Recurrence Question: "Second Tuesday" type recurrence pattern in Outlook | [email protected] | Outlook - General Queries | 3 | January 12th 07 12:54 PM |
Removing a recurrence | bill | Outlook - General Queries | 4 | November 8th 06 12:42 PM |