VBA code for sending email alerts automatically from excel sheet before due date mentioned in the sheet.My sheet contains date of work permits due dates.
He has several excellent article on sending email from Excel. You'll be using formulas to track which alerts need to be sent, and the script will use flags to keep track of which ones have already been sent.