Amend Email VBA Script

[Vinny1959]

I have a spread sheet which a kind guy on excel forum wrote some code to enable automatic email reminder up to 60 days before the expiry date. I have tried to amend it slightly so it send the email with additional information for use with another spread sheet. The code arranges for an email to be sent 60 days before expiry, but I would also like to send 30 & 14 days before expiry if the renewal date and details have not been updated.

I have included the original spread sheet "New Training Matrix" which works brill sending emails and shows the correct code to email and the "Testing Renewal" which would need the code looking at and amending.

I would appreciate any help.

Thanks

Vinny