I have got a spreadsheet with the following structure and many rows:
Column A: Last name
Column B: First name
Column C: Further information
Column D: Expiration date
Column E: Days remaining (Formula: today - expiration date)
.....
Column J: E-mail-address
Column K: E-mail content
Now I want an e-mail (reminder) to be sent to the e-mail-address in J3 if the value in E3 (remaining days) reaches a certain value (e.g. 90 days). This E-Mail should just contain the text of K3.
Equal process for all the single rows...
Ideally the mails should be sent automatically if the document gets opened and the certain value (e.g. 90 days) has been reached.
Many thanks in advance!
Bookmarks