I am setting up a spreadsheet, which includes a start date for a process and
wonder if I can link this to an outlook Calendar so that it reminds me
I am setting up a spreadsheet, which includes a start date for a process and
wonder if I can link this to an outlook Calendar so that it reminds me
I create an Outlook Appointment on my calender with results from a userform to remind me to invoice service job.
Hope this helps.
With OutlookApp.CreateItem(olAppointmentItem)
.Start = Date + 20 & " 2:00 pm"
.End = Date + 20 & " 2:00 pm"
.Subject = customer & " " & "Service Job #" & " " & TextBox1.Value & " ----> Invoice Due"
.location = location.Value
.Body = tbComment.Value
.ReminderMinutesBeforeStart = 1440
.ReminderSet = True
.Save
End With
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks