How do I write a macro or formula to send multiple outlook appointments/reminders

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.

Please accept my apologies for posting this question twice. Just as I posted the first thread, my cat decided to intervene and subsequently posted it for a second time.