Using Excel to send Multiple emails and logging

I am new to this so I will attempt to explain this the best I can
I have 2 sheets 'Scheduling' & 'Email Summary'
I am trying to set up a macro that will allow me to put rows of data on the Scheduling sheet and automatically make 3 high priority emails for each row entered
(one sends immediately, one 15 days prior ,and one 7 days prior) based off that information.
The columns I currently have set are 'due date'. 'email address', "cc email', 'email body' ,'Subject', and then 3 more columns that calculates the date 7, 15, 'Now'.
Once the emails are created and sent I need a list to populate on The email summary sheet that makes a log of all the emails that have been sent.
I need the log to make a continuous list based off each send but the user can delete the ones that are not needed anymore.