I've attached the spreadsheet (Office 2016) I use to track the due dates of apprentice reviews. When a date is entered in column H, columns K - Z populate with dates. row 6 shows the date reviews are actually due, and row 7 shows the window within which the review must be carried out. I have it set up so that when today's date falls within the review window (row 7), a formula prompts me to click in the data row (the attachment shows this in row 15). Clicking the prompt, produces a prepopulated email ready to send to the named assessor (email address) who will appear in column G. There will be various assessors named in column G.
I would like to add a formula/macro that will send calendar appointments to the email address in column G at the time when I populate the start date (Column H). I would like to send 8 appointments for the dates in row 7, columns K, M, O, Q, S, U, W and Y. I would want to repeat the process for each start date I enter, as I move down the spreadsheet. I just want to put dates in someone else's calendar (column G) as a first reminder of when reviews will be due. The automated email, will then give a second reminder when the review window opens.
I have found possible solution to this online, but I'm not knowledgeable enough to edit macros to suit my own spreadsheet. I'd really appreciate some help on this please.
Bookmarks