Link to home
Start Free TrialLog in
Avatar of mm72
mm72

asked on

Check if appointment already exists

I have created a addin which downloads a series of events from a php webservice and then adds them to the outlook calendar.

I know have a requirement to check if the appointment\event exists before te insert happens. this is to prevent duplicates of the same appointment.

I also need the abiity to change the appointment if the times have changed. Is there anyway of storing a ID number in the appointment.

Many thanks for any help. The code i am using to create the appointment is below.
Private Sub Btn2_Click(ByVal ctrl As Office.CommandBarButton, ByRef cancelDefault As Boolean) Handles btn1.Click
        Dim service As New wsclick.webservice
        Dim events As Array
        Dim uc As New wsclick.userCredentials
        uc.username = My.Settings.uname
        uc.password = My.Settings.pwd
        uc.database = My.Settings.db
        events = service.getEvents(uc)
 
        For Each cevent As wsclick.Event In events
 
 
 
            createEvents(cevent.subject, cevent.startdate, cevent.enddate, cevent.allday, cevent.description, cevent.timezone, cevent.remind, cevent.recurrenceperiod, cevent.recurrenceenddate, cevent.recurrenceoccurrences)
 
        Next
 
 
        MessageBox.Show("You have succesfully synchronised")
 
 
    End Sub
 
    
     Sub createEvents(ByVal subject As String, ByVal startdate As String, ByVal enddate As String, ByVal allday As String, ByVal description As String, ByVal timezone As String, ByVal remind As String, ByVal reccurrenceperiod As String, ByVal recurrencedate As String, ByVal recurrenceoccurencies As String)
 
 
        Dim oevent As Outlook.AppointmentItem = oapp.CreateItem(Outlook.OlItemType.olAppointmentItem)
        With oevent
            .Subject = subject
            .Start = CType(startdate, DateTime)
            .End = CType(enddate, DateTime)
            
            .Save()
        End With
    End Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mm72
mm72

ASKER

Thanks guys i managed to get it to work after reading the post listed