Trying to Get Email Sent With Correct Values

I have an excel sheet attached below,

What I am trying to do is to make excel send an automated email to the address stated in "G1".

Email will be sent according to the "Closing Date", this date is calculated by stating how many days allocated starting from the "Date Opened" for that case under "Days Allocated".

The email should include all the details from CASE ID, CHANNEL ID etc.

I no how to send emails for one row but I dont know if it is possible to do it for any row which expired.

The functions are there that check the expiry and email when the excel document is opened and check buttion, but I could not modify it properly as I took this code from another excel document on this forum.

Can anybody help?

Thanks