I watched a youtube video, copied a code and implemented it into my database. I had to change a couple of things to match my field name, but otherwise it worked well. Except, I don't know how to assign the task to someone. How do I assign a task to someone and have access email that person? Right now access just send the task to my email. Here is the code;
Private Sub Command83_Click()
Dim outLookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set outLookApp = CreateObject("outlook.application")
Set OutlookTask = outLookApp.CreateItem(olTaskItem)
.Subject = "Reminder for Task: " & Me.TaskTitle
.Body = "This is a reminder from Access 3 days before due. Task name: " & Me.TaskTitle & "is due on " & Me.Due_Date
.ReminderSet = True
.DueDate = Me.Due_Date
'remind 3 days before task due
.ReminderTime = Me.Due_Date - 3 & " 8:00 AM"
.ReminderPlaySound = True
.ReminderSoundFile = "C:\windows\media\ding.wav"
MsgBox "Task has been set in Outlook successfully.", vbInformation, "Set Task Confirmed"