Re: Check Column Of Dates Against System Date And Send E-mail If Match
This is a marcro I have made for universal information.
A1. First Name
B1. Last Name
C1. Email Address
D1. Begin Date
E1. Present Date
F1. Formula for Yes to send. Must copy down
G.1 Sent is inserted if email was sent.
H1. Date and time sent
I1. Subject line. "Annual Physical"
I2. First part of Body. "Hi"
I4. Date 31 days from present date.
To run it must have a "yes"in column "F" and no "Sent" in Column "G"
Remove the "sent" to run again to test.
I have it to display so you can verify the information before its sent.
The blue button runs the macro and the red one will pull up a calender. When you click on a date it will enter that date in the selected cell.