![]() |
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
|
|||
|
|||
![]()
Hi Friends,
We have almost done with the macro and it is working fine on some *machines.* We have one question. Could you please help on this and we are done. On some machine below portion of code works in strenge manner. For Each olkAppt In olkThisSeries MsgBox Date & " " & DateValue(olkAppt.Start) If Date DateValue(olkAppt.Start) Then Exit Do Set olkNewAppt = Application.CreateItem(olAppointmentItem) With olkNewAppt .Start = olkAppt.Start .End = olkAppt.End .Subject = olkAppt.Subject .Body = olkAppt.Body .Location = olkAppt.Location .ReminderSet = olkAppt.ReminderSet .BusyStatus = olkAppt.BusyStatus .Save End With Next The olkAppt.Start time returns always the date and time of first meeting and hence this loop goes in infinite loop. What could be the reason here? We also tried below code but no luck. Please note that it happens only on some machine while working on another machines. Do While True MsgBox Date & " " & DateValue(olkAppt.Start) If Date DateValue(olkAppt.Start) Then Exit Do Set olkNewAppt = Application.CreateItem(olAppointmentItem) With olkNewAppt .Start = olkAppt.Start .End = olkAppt.End .Subject = olkAppt.Subject .Body = olkAppt.Body .Location = olkAppt.Location .ReminderSet = olkAppt.ReminderSet .BusyStatus = olkAppt.BusyStatus .Save End With Set olkAppt = olkThisSeries.GetNext Loop Thanks in advanced |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying Appointement | Martin Racette | Outlook - Calandaring | 0 | February 22nd 08 05:35 PM |
Setup appointement for next week but always brings today's date | Benoit Lesage | Outlook - Calandaring | 6 | October 30th 07 02:10 PM |
Can you see when you submitted a new appointement? | Anne-Mette | Outlook - Calandaring | 2 | May 17th 07 01:27 PM |
Outlook 2000 Macro problem - Please help | [email protected] | Outlook and VBA | 1 | May 16th 07 04:40 PM |
Outlook Macro problem | Victor Delta | Outlook and VBA | 2 | December 9th 06 06:12 PM |