can i link a date in excel to my calendar in outlook?

J

jayne

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
 
T

try2XL

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
 
Top