vba create outlook event with list of dates and include table in description

[aspiringnerd]

I have 4 columns and a table that I want to use to create a new event in outlook.

Column P = Start date
Column Q = End date
Column R = Category
Column S = Subject

I also have a dynamic table that I have change based on xlookup, columns a1:h1000 (varies like I said between 50-100 ish rows).

I need help with some vba that will create an event with these cells, capturing only cells that are TRUE (true only after a44, since before a44 it's often blank) in the table so that I'm not copying all 1000 rows. And then Fill column O with a "sent" so I can track where I left off.

tldr = when you click the macro button it creates a new event with the table, dates, subject, and then adds "sent" in the corresponding row where the data was taken.

 

[aspiringnerd]

I'm going to try and break down each function, I really have a hard time understanding vba syntax:
looking for an if condition that checks for first instance of isblank in column 0
use the values in that row that it finds to create the outlook event
fill the row in column 0 to "sent" so that it will skip that row next time I run the macro