First of all thanks for all your help! I work at a nonprofit and we have a spreadsheet that has a person's name (Cell A1), person's email address (Cell B1), and date they need get their yearly physical (Cell C1).
What I would like is if today's date equals the date that they need to get their yearly physical send an email that says:
Hi (Insert Name)!
It is time for your yearly physical. Please complete this by (30 days from today's date).
Is this possible? If so, if one of you could provide the instructions on how to set this up, I would eternally greatful!