Microsoft >
Forums Home
>
Windows Phone Help
>
Help!!! - Problem with 1 year recurrences synchronization (Pocket Outlook - ActiveSync - MS Outlook 2007)
Help!!! - Problem with 1 year recurrences synchronization (Pocket Outlook - ActiveSync - MS Outlook 2007)
- Hello, I experiencing problem with Pocket Outlook and MS Outlook 2007 synchronization. Problem is that appointments which has recurrence set to 1 year like birthdays, anniversaries ... are correctly transferred from PC -> PDA (when edited by MS Outlook 2007), but when I made some modification to such appointments in PDA with Pocket Outlook (for example changing reminder time, name, ...) then after next synchronization when changes from PDA -> PC were sent the 1 year recurrence is changed to 12 years!!! And the worst and most frustrating thing is that when I synchronizing between two PCs then all appointments with such settings are changed from 1 year to 12 years!!!. Maybe it should be 12 months I'm not sure. I'm using Windows XP with Outlook 2007 and ActiveSync 4.5. Is there some problem with configuration or it's a bug? Strange thing is that this problem is related only to yearly recurrences (at daily,weekly and monthly recurrences there is no problem).
I test it also after clean boot of my device and the problem still persist. I also have a chance to make a test with HP device where is WM6.1 but with the same behavior as WM5.0. So I think that this is a bug inside the Pocket Outlook or ActiveSync with handling yearly recurrences. Can somebody clarify it? Is it possible to get a fix for this?
Thanks for quick response.
Daniel
Answers
I had this problem also - I missed some important yearly events because of it - exact same thing - changed yearly events to 12 yearly events. It would be good to get this bug tracked down.
The best way to check that this error hasn't occurred ...From the Calendar, select View, Current View, Events.
Now look for Events that are categorised as 'Recurrence: Yearly'.
It should say to the right, every <date>.
But some of mine showed up as 'every 12 years on <date>'
I double clicked on the ones that were incorrect and changed them.
Laura
- Edited byLaura RookeMVP, ModeratorFriday, 12 June 2009 2:44 PM
- Marked As Answer byWMTA3OwnerMonday, 15 June 2009 7:03 PM
- I'm not sure why that occurs Daniel but I had a similar experience. It did not occur with all of the 1 year reminders but enough that it was an issue for me. In my case they were ALL Day appointments (birthdays etc) so I decided to take the offending items and make them from a specific time (9am-10am) and used the reminder for once a year. So far that has worked for me.
Jack Cook
http://www.experiencemobility.net
http://www.mobilitysite.com- Proposed As Answer byJack Cook - aka Help_LineMVP, ModeratorFriday, 12 June 2009 2:02 PM
- Marked As Answer byWMTA3OwnerMonday, 15 June 2009 7:03 PM
- Hello,
finally I found a problem. The problem is in MS Outlook 2007. I uninstalled the Outlook 2007 from my PC and return back to MS Outlook 2003 and everything work fine like one expect. So I don't know how to inform the Microsoft that they have such bug, but a good thing is that there is no problem in WM5.0 or WM6.1. Maybe you have a possibility to inform Microsoft about such error. May be some group request for such fix can force MS to fix this problem asap.- Marked As Answer byWMTA3OwnerMonday, 15 June 2009 7:02 PM
All Replies
- I'm not sure why that occurs Daniel but I had a similar experience. It did not occur with all of the 1 year reminders but enough that it was an issue for me. In my case they were ALL Day appointments (birthdays etc) so I decided to take the offending items and make them from a specific time (9am-10am) and used the reminder for once a year. So far that has worked for me.
Jack Cook
http://www.experiencemobility.net
http://www.mobilitysite.com- Proposed As Answer byJack Cook - aka Help_LineMVP, ModeratorFriday, 12 June 2009 2:02 PM
- Marked As Answer byWMTA3OwnerMonday, 15 June 2009 7:03 PM
I had this problem also - I missed some important yearly events because of it - exact same thing - changed yearly events to 12 yearly events. It would be good to get this bug tracked down.
The best way to check that this error hasn't occurred ...From the Calendar, select View, Current View, Events.
Now look for Events that are categorised as 'Recurrence: Yearly'.
It should say to the right, every <date>.
But some of mine showed up as 'every 12 years on <date>'
I double clicked on the ones that were incorrect and changed them.
Laura
- Edited byLaura RookeMVP, ModeratorFriday, 12 June 2009 2:44 PM
- Marked As Answer byWMTA3OwnerMonday, 15 June 2009 7:03 PM
- Hello,
finally I found a problem. The problem is in MS Outlook 2007. I uninstalled the Outlook 2007 from my PC and return back to MS Outlook 2003 and everything work fine like one expect. So I don't know how to inform the Microsoft that they have such bug, but a good thing is that there is no problem in WM5.0 or WM6.1. Maybe you have a possibility to inform Microsoft about such error. May be some group request for such fix can force MS to fix this problem asap.- Marked As Answer byWMTA3OwnerMonday, 15 June 2009 7:02 PM
Hi dhajduch,
Thanks for replying with more specifics about the problem. (And thanks, to the MVPs for providing workarounds and tips!) I will pass this information to my colleagues at Microsoft.
Thank you from the Microsoft Windows Mobile Team
http://www.WindowsMobile.com/TotalAccess- Much appreciated. We have made sure this is documented and we'll share any further information when available.
Thank you from the Microsoft Windows Mobile Team
http://www.WindowsMobile.com/TotalAccess - Can you help with the details - I'd like to make sure that Outlook and Windows Mobile are aware of the issue.
1) Create an all day appointment on your desktop.
2) Set the appt to recurr every 12 months
3) Need to be using Outlook 2007 - using Outlook 2003 fixes the issue.
What mobile OS are you using WM 6? WM 6.1?
What dekstop OS - XP or Vista (ActiveSync or WMDC)
Thanks! - It has happened to me and I have a WM6.1 device and a Vista 64 bit laptop. The appointment was set to every 1 year and a number of them got changed to every 12 years.
Laura - Just thought I would add that my PCs are all 32 bit and it has happened on those machines
Jack Cook
http://www.experiencemobility.net
http://www.mobilitysite.com - I should add that when it occered with me I was experiencing the dreaded 86000107 error as well. Not sure if there is a relationship there....
Jack Cook
http://www.experiencemobility.net
http://www.mobilitysite.com - And I have absolutely no reason to think this but I suspected my iphone , when I chose to sync my Calendar with my iphone - so I'm just wondering.....
Laura - This has also happened to me, and this using outlook 2007 with a Palm-OS treo 600 syncing using Hotsync, so it looks like a Outlook 20007 Problem...
Still, saves you money on birthday/anniversary gifts...
Cheers
B_V - I noticed this when I first started using Outlook 2007, synced with a pocket pc (wm5) and synced with Outlook 2003.
It was a known problem according to my research via google, although no solution was available. Several months later, I am disapointed that Miscrosoft has not fixed the bug.
After reading this thread, I can now manually fix the problem items, although it would have been better if Microsoft had done this. I canh only assume Outlook 2003 recorded an annual event occuring every 12 months, and Outlook 2003 uses the same field to record years.
I assume this problem has existed for over 2 years. How long do we have to wait for Microsoft to fix this bug? How many people have missed events due to not knowing about this bug? I know I have missed birthdays since I have been relying on Outlook 2007 (my main computer) to show such entries in the calendar. I shouldn't have to rely on my pocket pc (with it's small screen and un-user friendly keyboard).
If I still had the licence to use Office 2003, I would use it on my main computer. It has certainly put me off upgrading my old computer.
IM - Hello dhajduch and others!
I have the same problem when synchronizing birthdays from Windows Mobile 6.1 Calendar to Microsoft Office 2007 Outlook. They are changed to occur every 12 years instead of 1 year when synchronizing from Windows Mobile to Outlook 2007.
I just purchased a Sony Ericsson Xperia X1 smart phone 3 weeks ago and tried to synchronize it with my workstation and labtop.
The workstation is 64-bit and runs Windows Vista Business 64-bit. Microsoft Office Small Business 2007 with the latest updates pr. today (incl. SP2).
The labtop is 64-bit and runs Windows Vista Business 32-bit. Microsoft Office Small Business 2007 with the latest updates pr. today (incl. SP2).
The X1 runs Windows Mobile 6.1 with the latest updates from SE.
After 3 weeks of searching the internet, communicating with SE support (the say they cannot create the problem) and doing other testing i finally narrowed down the problem.
I did the following:
- Created and formatted a new partition on my workstation's harddisk.
- Downloaded and installed a version of Windows Vista Busines SP2 64-bit in the new partition.
- Downloaded all updates to the Vista including drivers for Nvidia display.
- Downloaded a Microsoft Office 2007 Standard trial version and installed it (choosed Standard instead of Small Business to make it easier).
- Installed WMDC and connected the X1.
Nothing else to interferre.
Ready to go. I created a birthday on the X1, synchronized it to the workstation. It occurs every year.
Tried to create birthdays on the workstation, sync to the X1, modify them there and sync back to workstation again.
Everithing was fine.
Then I updated Office with SP2 and all other updates found by Windows update.
Restarted the workstation and X1 and tried again.
When synchronizing from the X1 calender to the Outlook-calender on the workstation all birthdays were changed from 1 year occurence to 12 years occurence.
So the problem is in the SP2 for Office 2007.
They must have changed something and forgot to inform the developers responsible for Mobile synchronization!!!!!
Hopes this can spread a little ligth and get the problem solved.
Otherwise, I do love the SE Xperia X1 - thats why I purchased it.
Best regards
Niels Oluf - Niels, thanks for passing that info on.
Jack Cook
http://www.experiencemobility.net
http://www.mobilitysite.com This issue is really quite annoying. I've been dealing with it for at least a year now, and I have missed some things because of it. My wife just got a Palm Pre and has started synching with Google and Facebook instead of Outlook. So far, the synchronization has been flawless. I really love Outlook when it works, but these bugs are beginning to make me wonder if it's worth sticking around. Longing for good clean synchronization, but beginning to have a wandering eye...
- I'm also experiencing a corruption of all annual recurring all day events - changing them to recurring every 12 years as described above. This is happening when I sync between my Windows 7 RC - Outlook 2010 CTP (Home PC) -> Windows Mobile 6.1 HTC HD -> Windows XP - Office 2007 SP2 (Work PC). It doesn't matter if I fix them all on my work pc and then sync back to home pc or vice versa - the data corruption is the same and consistent. It would be great to hear if MS have released a hotfix for this issue as from reading this thread they should have been aware of the error in Office 2007 SP2 for some time now.
- I've see the exact same problem. It has wasted way too much of my time. I've tried changing to "occurs every 12 months" but it just gets changed back to every 12 years. I ysnc between two PCs - work and home. It looks ok for a sync or two and then it goes haywire again. At work it looks ok (Exchange Server) the problem is only presented at home on Outlook 2007
- I also have the same problem. I'm using Windows Mobile Professional 6.1, and 2 Vista Ultimate machines (PC + laptop) all running the latest patches.
I used a Windos mobile 6.0 phone to get all my appointments and contacts from Office 2003 of my okd PC to Office 2007 on my new PC.
Then I used a Windows mobile 6.1 phone with active sync to get all my contacts and appointments to the mobile phone and my laptop.
Then I noticed on my PC that all my yearly appointments had a 12 year recurring schedule. So I changed all of them, about 120, back to a 1 year schedule.
After active sync to my mobile device from my PC, and then active sync to my laptop I saw that on my laptop now all yearly appointments have a 12 year recurring schedule!!
Then I decided to correct about 30 12 year recurring appointments on my laptop back to 1 year recurring.
After active sync laptop -> mobile and mobile -> PC now my PC shows 12 year recurring schedules for the 30 ones I corrected on my laptop.
So if I correct the appointments to 1 year recurring on my laptop they will be set to 12 year recurring on my PC. Vice versa if I correct them on my PC to 1 year recurring they will be incorrectly replicated to my laptop.
In short, I can't correct the problem, and I'm really sick about this. This is a MAJOR bug, if you have an agenda program continuously messing up appointments then it just is a worthless product. Please fix this ASAP before I lose thrust in Outlook agenda's. In the meantime Windows live also replicated all my contacts as duplicates back to my mobile device, so I had to remove all 500 duplicate contacts. Luckily this problem did not occur again. Again, this kind of bugs are killing the Microsoft brand name. - I am still getting this problem with my annual events randomly changing from yearly to 12 yearly. I put calendar into annual event view to check them out and repair them. I agree - Microsoft really need to address this very annoying bug. I have missed a number of birthdays because of this.
Laura - Although it is not a "fix" for the issue, I decided to take the offending items and change them to a specific time (9am-10am) and used the reminder for once a year. So far that has worked for me. In fact, virtually all my Birthdays are now converted and truthfully, I like doing it this way better.
Jack Cook
http://www.experiencemobility.net
http://www.mobilitysite.com I finally just decided to create my own custom calendar view in Outlook by copying the "Annual Events" view and adding a filter to only include Recurrence Pattern values that contain "every 12 years". Now it has become part of my synchronization routine to always check my custom calendar view and manually fix each offending culprit. Doesn't seem to happen every time I sync, but still happens enough that I check every time. It's interesting to see how it seems to randomly affect various numbers of events.
- It seems to happen mainly and randomly with recurrent events that have no end-date. This is the setting by default if you enter a birthday in your outlook contacts. So I have entered the birthday, gone to the date and then set it to end after 100 years, as well as for other anniversaries. You could say that MS just wants to remind us that we and all our friends are mortal. Or is it converting to dog years? :-D
I have 600+ annual recurring events. As mentioned above, all of these annual events have no end date.
I am running Vista on one home machine with MS Outlook 2007 and Windows XP Pro with MS Outlook 2003 on my work machine. I fixed this problem several months ago by re-entering every 12 year event to a 1-year event. Things were running fine for the last 2 months.
I just returned from an extended trip in a different time zone where I had set my WinMO 6.1 PDA system to the time in the new city. I set the time back to my home time when I returned and then I synced with my work machine and have no problems. I synced with my home machine and now every annual event on the home machine is back to repeating every 12 years. When will a fix be available from MS regarding this problem?- I have the same problem. Vista with Office 2007 @ Home, XP with Office 2003 @ Work.
At home, with Vista and Office 2007, I get the problem too.
I think, the problem came with an office hotfix or patch. There was no problem before afaik (spring 2009).
Realy an annoying bug.
I just looked at WindowsUpdate. On 2009/04/30 Office Service Pack SP2 was installed.
And when I look in the knowledgebase http://support.microsoft.com/kb/953195 some things where changed in outlook calendar.
As I saw in other (german) newsgroups there bug came up in may/june 2009.
So SP2 might have caused the problem. - WMTA3 and MaryAliceC,
I just looked for my Christmas Eve calendar item. There are two on December 23. On the 24th I have two Christmas Eve items and two Christmas Day ones.
You appear to be Microsoft employees. Regardless, can you get urgent messages to the Outlook development manager?
Paying customers have a product that doesn't work, is destroying valuable data and wasting time. How is that different from theft and sabotage? Does anyone there see it that way? For any other company that understands the damage being done, this would be a terminable offense.
The ethical thing for Microsoft to do is to put a team (ideally, the original SP2 hackers) in a building, provide cots, and tell them they can come out when the problem is fixed. They might also need to write a utility to assist customers in finding the correct records in the current and archive PST files, and backups, or suggest mitigation for every corrupted record.
But first, find and destroy every Blackberry or iPhone that is being used by anyone on the development or support team. Give them all Windows Mobile devices. They obviously aren't using them now. Why not? Because it's inconvenient?
Your help will be appreciated, but probably not by anybody inside Microsoft. They don't matter. The posters here do.
-an IT Manager
The ethical thing for Microsoft to do is to put a team (ideally, the original SP2 hackers) in a building, provide cots, and tell them they can come out when the problem is fixed. They might also need to write a utility to assist customers in finding the correct records in the current and archive PST files, and backups, or suggest mitigation for every corrupted record.
But first, find and destroy every Blackberry or iPhone that is being used by anyone on the development or support team. Give them all Windows Mobile devices. They obviously aren't using them now. Why not? Because it's inconvenient?
Ok. That's was the first laugh I've had in the past week of trying to fix my calendars. I can't believe MS is this incompetent.
In addition to the "every twelve year" but, I also have it moving dates around . . . Christmas . . . New Year's . . . even THANKSGIVING! And it's moved birthdays. And since I don't have "hard copies" for many of them, now I'm guessing what the correct dates are.
I'm syncing my HTC Fuze (Touch Pro) to my home Vista-64 PC and Google Calendar. I originally thought it was Google calendar who was the culprit, so I deleted that exchange server. But alas, after a couple of hours of working on correcting my calendar, the same problem!!!!
Can we get a "Microsoft update" for this ASAP????I was experiencing this problem when I had my WM6 device configured to sync with both Outlook 2007 (on Windows 7 64 machine) AND my Google account. I removed all partnerships and then configured my device to only sync with desktop Outlook 2007 (left Google out) and the problem has disappeared completely for me. I think the problem may arise when you have multiple sync partnerships defined in ActiveSync on your device. At least it appears that way based on my observations.
I considered setting up my desktop Outlook to sync with Google using Google Sync (and then just configuring my device to sync with Google), but the free Google service only provides calendar sync (no contacts), so that configuration won't cut it. I am seriously considering eliminating desktop Outlook from the scene entirely and just synching with Google.- I must say - I am thrilled to have found this link regarding problems sync-ing Outlook 2003 to Win Mobile 6 - to Outlook 2007 for annual events - I have just forgotten my sis-in-law's birthday and I would never have missed it if it came up on my calendar - I have the same problem - Some occur every 12 years - But I am also having trouble with the following:
I have over 30 annual events that are listed as occurring once yearly but they are NOT displayed in the day/week/mth view on my calendar!!! I have to actually go into 'recurrances' and click 'ok' even though I haven't made any changes to get the events to display. Then, when I do the sync again, I lose some (this seems random to me, although I'm trying to look for a pattern). This is driving me crazy!! Anyone have a similar problem?
PS - To Daboodah - Can I really just use Google instead? What about my 1000s of contacts? - Does anybody know if this strange sync problem is fixed now with the latest outlook updates from Microsoft?
- I have concluded that the issue is multiply device syncs.
I was syncing Outlook2007<=>WindowsMobile6.1<=>Outlook2003. I have now removed the Outlook2003 and it appears that the issue is resolved.. DocCyn - I believe you could use Google to also sync contacts if you sign up for a Google Apps account ($50 per user per year). However, I don't know that it will sync Outlook tasks, which is something that I actually use heavily. Still looking for that perfect solution...actually beginning to consider paying a monthly fee for a hosted Exchange service for personal use.
- Just adding my two cents that this has not been solved. Adding an end date does not work, deleting and recreating does not work, trying changing it to recurrence of every 12 months does not work. Someone at Microsoft needs to get on this.
- Hi, all. This problem is most certainly related to Outlook 2007 since starting with this version the ability to set an appointment's recurrence to "every N years" was introduced. Such recurrence setting is not available in WM's calendar. Furthermore, I believe the problem is likely to happen only when a WM device is synced with more than one computer running Outlook 2007. Microsoft still does not have a solution and neither do I but here is a simple remedy in the shape of a VBA script that patches up all "bad" appointments and I run it every time I notice this problem
Sub ChangeIntervalFrom144To12()
Dim ai As AppointmentItem
Dim rp As RecurrencePattern
For Each ai In ActiveExplorer.CurrentFolder.Items
If ai.IsRecurring Then
Set rp = ai.GetRecurrencePattern
If rp.Interval = 144 Then
rp.Interval = 1
ai.Save
End If
End If
Next ai
End Sub
You must have your calendar folder as the active tool when you run this macro. BEWARE: if you do have a legitimate appointment with recurrence every 12 years this script will also set it to every 1 year. As you might have guessed, use this script at your own risk and don't point a finger at me if something goes badly :)
- Proposed As Answer bydon Sjon Thursday, 17 December 2009 2:48 PM
- Thank you for sharing Viade!
Thank you from the Windows phone team
http://www.WindowsPhone.com/TotalAccess - I'm having the same problem.
I just rebuilt my computer with Windows 7 64 bits. Previously I was using Windows XP Home + Outlook 2002 with no issues with the calendar. Because Outlook 2002 doesn't work with Vista or Windows 7, I had to install the trial of Outlook 2007 included with my Touch HD. Then I installed the SP2 for Office 2007. And then the problem started. I sync my PocketPC at home and work, every time that I go from one computer to the other my all-day appointments that occur every year are changed to occur every 12 years. So MS forced me to use Outlook 2007 only to find that it has such a huge bug!
I tried setting and end time, as has been suggested, but this doesn't do anything.
Has anyone tried uninstalling the SP2 from Office 2007? I can work fine without SP2, but not with an unreliable constantly changing calendar.
Thanks - I am having the same problem and tried and underwent without success what many here have described before.
Now I am just wondering what it would take to get some response of acknowledgement from Microsoft, or even a statement that they are working on this. They cannot seriously ignore this until maybe everybody has advanced to Windows Mobile 6.5 or above and the most recent versions of all possible software involved - assuming / hoping that the problem would then disappear.
I hate it to be forced to vote with my feet, or wallet for that matter and make an investment decision away from unresponsive partners.
Thanks!- Proposed As Answer byRonEMc Tuesday, 17 November 2009 2:57 AM
- I have the same issue. It's extremely frustrating and none of the suggested methods, such as setting an end date or changing to every 12 months, works.
I'm using Outlook 2007 (SP2) on two machines. One with XP Pro (work) and the other with Windows 7 (home). My handheld device is the HTC Imagio running WM 6.5 and is set to sync with work's Exchange Server 2003.
I created several new recurring events on the Windows 7 machine, sync'd with the HTC, no problem. At work this morning I sync'd and all appeared ok. However, when I got home tonight and sync'd, all the new recurring events were changed to repeat every 12 years. Some were even changed to every 12 years from 1:00 AM to 1:00 AM, instead of 12:00 AM to 12:00 AM. To me, that sounds like a potential daylight savings time issue, but not sure. Any thoughts?
Also, the XP machine and WM 6.5 device use GMT as the time zone, where Windows 7 uses UTC. I doubt that matters, but who knows.
I can't believe Microsoft hasn't come out with a fix yet.
Any suggestions are greatly appreciated.
Ron - Hello
As far as I can ascertain, this is not a Windows Mobile issue, but an Outlook 2007 problem (come on Microsoft, just call it a bug).
I am sync'ing a Handspring Treo 600 with Outlook 2007 on two PCs (one XP , one Vista). The 12 year problem only seems to appear on the "second" PC that is synched. I mean it like this:
1. Corrected all yearly reccurences on one PC (PC1).
2. Overwrote handheld with correct data.
3. Reccurences on Handheld and PC1 correct.
4. Overwrote second PC (PC2) with data from handheld.
5. Reccurences on Handheld and PC2 correct.
6. After some sync'ing back and forth, Reccurences on PC2 turned to 12-yearly-
7. Appointments on PC1 and Handheld are STILL correct (yearly)
This is the status after some weeks of daily syncing. I can reset the reccurences on PC2 to yearly, they will revert to 12-yearly after syncing.
As I use HotSync Manager 4.1 from Palm, i doubt the bug is in Windows Mobile, but I point my finger at Outlook, specially as this problem seems to have appeared after an update of Outlook.
Question:
Does anybody know which outlook update provoked this? Can it be de-installed?
On the other hand, maybe Microsoft has noted this problem, but the appointment has turned to 12-yearly and they will not get the reminder in their Outlook till 2021....
Thanks for help, ideas and general, sympathetic grumbling & moaning
Svend - Thanks,
This solves the prob for me (or at least it is a workaround, better this then nothing)
my situation.
2 PC's both XP SP3
1 WM 6.5
on 1 PC office 2003, the other office 2007
on the office 2007 I see it changing to every 12 years, on all other devices (ol 2k3 and wm6.5) it is ok.
The macro Viade provided solves the problem for me. However, all of the yearly appointments I have in the summer (i.e. birthdays) are off by an hour (starting at 1AM). I guess I'll have to hunt this one down now unless anyone knows the fix for this bug too?
- Viade,
thanks for that script, it has saved me hours every week.
I had an error with one of my appointments (somehow end time was before start time) that caused your script to crash, so I've posted my change to your script with an error handler below. I've also set it to cap the number of occurrences to 100, as setting an end date seemed to help alleviate the problem in the first place.
Additionally, below that is another script that corrects the end date to be the right amount of time after the start date - if you manually change a 12 year recurring appointment to 1 year recurrence (as I used to before finding your script) and don't touch the boxes for number of occurrences / end by date, it will leave the end date as 12x as far in the future as it should be (eg 1200 years, not 100). This isn't needed if you're just running the first script, only if you've manually edited appointments with a 12 year recurrence.
Sub ChangeIntervalFrom144To12()
Dim ai As AppointmentItem
Dim rp As RecurrencePattern
Dim Countup As Integer
Dim Continue As Integer
Dim Corrected As Integer
Dim ErrorTitle As String
Dim ErrorTime As String
Countup = 0
Corrected = 0
For Each ai In ActiveExplorer.CurrentFolder.Items
Countup = Countup + 1 'determines current item number
On Error GoTo ErrorReport
If ai.IsRecurring Then
Set rp = ai.GetRecurrencePattern
If rp.Interval = 144 Then
rp.Interval = 1 'changes recurrence from 12 years to 1 year
rp.Occurrences = 100 'caps at 100 ocurrences to prevent problem from happening again
ai.Save
Corrected = Corrected + 1 'counts how many instances have been corrected
End If
End If
Skip:
Next ai
MsgBox Corrected & " recurring appointments corrected from 12 year repeat to 1 year"
GoTo Finish
ErrorReport:
ErrorTitle = ai.Subject
ErrorTime = ai.Start
MsgBox "Record " & Countup & ", title " & ErrorTitle & " on " & ErrorTime & ", caused the error."
Continue = MsgBox("Continue?", vbYesNo)
If Continue = vbNo Then GoTo Finish
GoTo Skip
Finish:
End Sub
----
Sub CorrectRecurrenceDates()
Dim ai As AppointmentItem
Dim rp As RecurrencePattern
Dim Number As Integer
Dim First As Date
Dim Final As Date
Dim Difference As Date
Dim Countup1 As Integer
Dim Continue1 As Integer
Dim Corrected1 As Integer
Dim Title1 As String
Dim NoEnd As String
Dim ErrorTitle1 As String
Dim ErrorTime1 As String
' Reset all variables
Countup1 = 0
Corrected1 = 0
NoEnd = 0
' Cycle through all appointments in the current folder
For Each ai In ActiveExplorer.CurrentFolder.Items
Countup1 = Countup1 + 1 'determines current item number
On Error GoTo ErrorReport
If ai.IsRecurring Then
Set rp = ai.GetRecurrencePattern
' Only consider appointments that repeat every year - looking at other recurrence patterns would require a different calculation for "Difference" below
If rp.Interval = 12 Then
' Get number of occurrences, recurrance range start and end dates
Number = rp.Occurrences
First = rp.PatternStartDate
Final = rp.PatternEndDate
Difference = (Final - First) / 365
If Final = "31/12/4500 23:59:00" Then GoTo NoEndDate
' Compare whether the number of years between start and end date is the same as the number of occurrences
If Difference > Number Then
' The next two commented lines can give a pop up box with details of the erroneous appointment if uncommented
' Title1 = ai.Subject
' MsgBox (Title1 & " starting " & First & " and ending " & Final & " has an error")
' The next two lines correct the problem and save the corrected appointment
rp.Occurrences = Number
ai.Save
Corrected1 = Corrected1 + 1 'counts how many instances have been corrected
End If
End If
End If
' End If
Skip:
Next ai
MsgBox "End dates corrected for " & Corrected1 & " recurring appointments" & vbNewLine & vbNewLine & NoEnd & " recurring appointments with no end date ignored"
GoTo Finish
NoEndDate:
NoEnd = NoEnd + 1 'counts how many appointments with no end date have been encountered
GoTo Skip
ErrorReport:
ErrorTitle1 = ai.Subject
ErrorTime1 = ai.Start
MsgBox "Record " & Countup1 & ", title " & ErrorTitle1 & " on " & ErrorTime1 & ", caused the error."
Continue1 = MsgBox("Continue?", vbYesNo)
If Continue1 = vbNo Then GoTo Finish
GoTo Skip
Finish:
End Sub - Viade and Jeremy T.,
Thanks for the script(s). Do you run them in the VB editor in Outlook itself?
Ron - Has someone tried with the new Outlook 2010 beta? If MS doesn't release a fix by the end of the month, my Outlook 2007 trial will expire and I'm not purchasing it as broken as it is now.
- Proposed As Answer bySevin Monday, 11 January 2010 2:55 PM
- The problem is still there in Outlook 2010 Beta. I am syncing two PCs, both on Office 2010 Beta, with a Windows Mobile 6.5 PDA. After the sync the recurring yearly calender entries disappear from the weekly calender view. I had this also on Office 2007 for the last two years.
I am using this VB script to simply rewrite these entries. After running the script the entries are back. No change is required in the end dates.
-----------------------------
Sub SetRecurrenceType()
Dim olApp As Outlook.Application
Dim objAppointment, objRecurring As Object
Dim objAppointments As Outlook.Items
Dim objNameSpace As Outlook.NameSpace
Dim objProperty As Outlook.UserProperty
Dim s As String
Dim i As Integer
Dim changed, recurring As Boolean
Set olApp = CreateObject("Outlook.Application")
Set objNameSpace = olApp.GetNamespace("MAPI")
Set objAppointments = objNameSpace.GetDefaultFolder(olFolderCalendar).Items
i = 0
For Each objAppointment In objAppointments
i = i + 1
If objAppointment.Class = olAppointment Then
If objAppointment.IsRecurring Then
changed = False
Set objRecurring = objAppointment.GetRecurrencePattern
If objRecurring.RecurrenceType = olRecursYearly Then
objRecurring.RecurrenceType = olRecursYearly
objAppointment.Save
End If
End If
End If
Next
MsgBox Str(i) & " Entries rewritten"
End Sub
------------------------------------------
To use macros on Office 2010 you need to add "development tools" to the ribbon bar.
Rgds, Sevin
- I'm sorry to inform you that the rp.Occurrences = 100 solution does not help the problem, I tried it without result.
The situation is still the same. After syncing between Windows 7 and Outlook 2007 to Outlook on Windows Mobile 6.5 and syncing back to Windows 7 and Outlook 2007 on my laptop always on of my machines has all my yearly recurring appointments recurring at 12 years, and the other PC at 1 year. If I run the macro on one machine after snycing to the other machine all yearly appointmens are set back to 12 year recurring appointments.
The lack of response from Microsoft really disappoints me. - Sevin, thanks for the confirmation. I have also installed Outlook 2010 beta to test it and the same issue happens :(I have done some extensive testing during the last two hours to see if I could find the right mix of software to get around this problem, but no luck. However I've come up with information that can help Microsoft trace the source of this problem. I posted it on XDA-Developers, if someone wants to take a look:Basically the problem seems to be caused because Outlook 2007 SP2 (including Outlook 2010 beta) introduced some changes that break calendar synchronization in ActiveSync 4.5 and Windows Mobile Device Center 6.1. If you have one computer it's a small problem because once you correct the data, the repetitions stay (or it may not affect you at all if data is feed from the computer to the PocketPC and not the other way around -for instance, in case of a new install of Outlook when you want to dump all your PocketPC data onto a new computer-).The only work-around seems to be this VB script. Thanks to those that spent their time creating it.
Update: The change was introduced with SP2, not SP1! So simply uninstall the Office 2007 SP2, and stick to SP1 + all security updates! It's not ideal, but we have no choice until MS fixes WMDC and ActiveSync (I doubt this gets any more updates). - I am having this problem as well - Outlook 2007 is on both machines, and an HTC Touch Pro with WM 6.1 syncs them. Interestingly, at least so far, only one of the machines has switched over to "once every 12 years" for all of my annual appointments. The other has kept "every [Month] [Date]." But the problem is it screws up whether these appointments get displayed on my mobile calendar and my work calendar, so I end up missing some things. I will try running the code sample that some kind soul came up with.
- Hello,
I'm new here and really would like to use this fix (script) but I have no idea how to run a script. I have only one calander on Outlook 2007 and 1 computer running XP and only 1 phone (HTC Touch Pro) that I sync with Outlook. How do I run this script to fix my issue with the 12year recurrences? Thank you very much for the help!!!!
I have missed way to many appointments over the past 6-7 months and I am VERY happy to have found some type of workaround.
-Tony
b727pilot at Hotmail dot com (if it is easier to send me an email on how to run this script). To run one of the VBA scripts posted here in Outlook 2007 you need to switch to Outlook window and switch to calendar view in there. Hit Alt+F11 keys and Microsoft Visual Basic window comes up. In this window hit Ctrl+R kes to switch to Project Explorer tool. Normally you will find there item called Project1. Expand this item and then expand Microsoft Office Outlook Objects item and then double-click ThisOutlookSession item. This opens a new script window. Copy and paste the script code into this window and hit F5. This should run the scrip and hopefully produce the desired result. Good luck.
- Viade,
Thank you Very much for the info! This 1 year thing has been killing me for a while now. I'll give it a go and see if I can fix it. Thanks again for the help on how to run the script(s).
-Tony - Question on running the VBA scripts: yesterday they ran fine, but today I am getting the message, "The macros in this project are disabled..." How can I get it to run again?
thanks,
mike
Office PC: XP, Office 2007
Home PC: Windows 7, Office 2007
ATT Tilt 2: WM 6.5 I'm done with Windows Mobile, after over 8 years straight using it, the latest round of problems with desktop synchronization and the lack of interest to fix them that Microsoft shows has been the last nail on the coffin.
It seems that desktop synchronization is an area that MS is no longer interested in, and wants to move the users to other ways of getting the information: Exchange (as if everybody could use it) and maybe some cloud services like MyPhone. If I have to move in this way, I no longer need Outlook (my trial version expires this Sunday, and of course I will not purchase it -anyway the Spanish website where you're supposed to purchase it doesn't work-). And I no longer have to stay with Windows Mobile, either. So I got an Android device and moved all my data to it. And by one of those weird twists of life, it has HTC Sync, a software that reliably syncs with Outlook 2010 (and 2007 SP2), although I no longer need that.
[/rant]
Sorry, I can't offer help to fix this particular issue besides uninstalling the SP2 of Office 2007 (SP1 is safe) on all the computers where you sync by means of ActiveSync or Windows Mobile Device Center. And stay at that, don't upgrade to Office 2010 or newer Service Packs. At least until the Windows Mobile team decides they have to fix AS and WMDC before loosing more customers that rely on desktop synchronization.
Just curious if anyone tried removing Office 2007 SP2???
- I looked into it. One needs a Service Pack Uninstaller from the MS web site. The common uninstall from the control panel can't do it.
After I downloaded that uninstaller I ran it, but found the output rather confusing. My conclusion is that it's probably easier for the lesser skilled to de-install the Office suite and install it again. Then do the online updates, but omit SP2. But I haven't come around to do it - and probably try to postpone this hoping for a program fix by Microsoft.
Juergen - Yes I agree and would hope that Microsoft would put a fix out for this but what are our chances. My company is looking into Window Mobile devices as a standard and this could definitely kill it from a business perspective.
- See my post http://social.microsoft.com/Forums/en-US/windowsmobile/thread/0f221f6f-ad65-4335-91de-900b3885a71c for another work around.
Bern_viking,
Your detail is EXACTLY what I am experiening. I wish I knew what Outlook update caused this issue. All I have been able to find out is that it is caused by MS Office 2007 Service Pack 2 wihich cannot be removed normally. Microsoft has a special removal tool, command line based to do this but I just rebuild my home computer and really don't want to do this. The only difference in my situation is I am using active sync 4.5 and a windows mobile 6.1 device.
Best Regards and good luck to all of us with getting Microsoft to consider this important. I thought they would since many large companies are considering windows mobile devices for their standard communication device.
