Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

add Outlook Calender reminder to another user calender

Status
Not open for further replies.

neemi

Programmer
May 14, 2002
519
GB
Access 2000

Our Outlook is based on exchange server and what I need to be able to do is add an outlook calender reminder to for another user.

Currently I have the following code:

Code:
Public Function SetOutlookReminder(vtApptDate As Variant, _
                                   vtApptTime As Variant, _
                                   strSubject As String, _
                                   strbody As String, _
                                   intRemMinsBeforeStart As Integer, _
                                   blnSetReminder As Boolean) As String
On Error GoTo ErrorHandler

'// =================================================================================
    Dim sMessage As String
    Dim strEntryID As String
    Dim strStoreID As String
    
    Dim objOutlook As Outlook.Application
    Dim objAppt As Outlook.AppointmentItem
        
    Set objOutlook = CreateObject("Outlook.Application")
    Set objAppt = objOutlook.CreateItem(olAppointmentItem)
           
    With objAppt

        .Start = vtApptDate & " " & vtApptTime
        .End = vtApptDate & " " & vtApptTime
        .subject = strSubject
        .Body = strbody
        .ReminderMinutesBeforeStart = intRemMinsBeforeStart
        .ReminderSet = blnSetReminder
        .Save
        .close (olSave)
    End With
    
    strEntryID = objAppt.EntryID
    SetOutlookReminder = strEntryID
    
    Set objAppt = Nothing
    Set objOutlook = Nothing

Exit_ErrorHandler:
    Exit Function

ErrorHandler:
    MsgBox Err.Number & " - " & Err.Description, vbOKOnly + vbExclamation, "CLM Outlook Reminder Error"
    Resume Exit_ErrorHandler
    Resume 0

End Function

But this adds the reminder to the current users outlook.

Does anyone know how I can add a reminder to outlook so that it appears in someone elses calender by specifiying which users calender i want it to appear in???

Help greatly appreciated...

Cheers,
Nims
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top