The following code puts Job details into MY outlook calendar (and obviously into the Calendar of any users who create the record).
What I need is for the Calendar entry to go into my colleague Dan's shared calendar, regardless who creates the entry.
We are using Access 2010, Outlook 2010 and Exchange server 2003.
Hope you can help.
Private Sub Work_Date_AfterUpdate()
Dim oApp As Object
Dim oNS As Object
Dim oCalendar As Object
Dim ofold As Object
Set oApp = CreateObject("Outlook.Application")
Set oNS = oApp.GetNamespace("MAPI")
Set oCalendar = oNS.GetDefaultFolder(9)
Set ofold = oCalendar.Items.Add
With ofold
.Subject = Me!engName & " to " & Forms![Job Reports]!Site & " SR " & Forms![Job Reports]![Job Number ID] & " - " & Forms![Job Reports]![Work Request Details]
.Start = Forms![Job Reports]![Date] 'start date/time of entry
.Duration = 30
.ReminderMinutesBeforeStart = 1440 'minutes in a day
.Save
End With
Set oCalendar = Nothing
Set oApp = Nothing
End Sub