I'm afraid this might be difficult. Any assistance is much appreciated.

I want to create a macro or VBA that sends out reminder emails to addresses in one cell based on a date in another cell on the same row. This woyuld be to remind the recipients that their closing date has arrived and that action is required on their end.

The attached picture shows a simplified version of the data I'm working with.

So the email would be automatically sent to the address in E, based on the date in D. Preferably the email would have blanks that could be filled in with info from A, B and D. And if F could be filled in with sent/not sent that would also be terrific.

Is there any way of going about this? or is it too complex?

Sample.png