Hello,

I have an excel file with a list of 50 suppliers in col A, in col B is a deadline date they have to submit their report by.

In col C is the supplier email address.

Can someone advise me on how to set up macro so when we approach the deadline date, a email is sent to the supplier to remind them to submit their report asap.I am new to macros, can you please HELP!