Can someone help me out with some code to update a an outlook task to complete from microsoft access. I am using the following code to add a task to outlook from a form:
Dim appOutLook As Outlook.Application
Dim taskOutLook As Outlook.TaskItem
Set appOutLook = CreateObject("Outlook.Application")
Set taskOutLook = appOutLook.CreateItem(olTaskItem)
With taskOutLook
.Subject = Me.Subject
.DueDate = Me.DueDate
.Body = Me.Body
.Complete = False
.ReminderSet = False
.Save
End With
DoCmd.Close
How can i use the same form, by checking the completed field in access and then update it in outlook?
Dim appOutLook As Outlook.Application
Dim taskOutLook As Outlook.TaskItem
Set appOutLook = CreateObject("Outlook.Application")
Set taskOutLook = appOutLook.CreateItem(olTaskItem)
With taskOutLook
.Subject = Me.Subject
.DueDate = Me.DueDate
.Body = Me.Body
.Complete = False
.ReminderSet = False
.Save
End With
DoCmd.Close
How can i use the same form, by checking the completed field in access and then update it in outlook?