Book2.xlsx

Ok I'm thinking this might be easier. I want to have a code that I can put in multiple worksheets throughout the workbook that will send an email when the date in column AE is reached. I hopefully want to see if it can only send one email per day no matter how many dates are reached or how many times the workbook is opened. Also is it possible to have something like this run automatically without opening the workbook?