Dear experts,

I've a database of clients' information. Column A is clients' names; column
B is account numbers; column C is subscription dates; column D is expiry
dates.

My question is, if I set a formula in column E which shows "Renewal" if
expiry date minus today is less than 30 days. Subsequently, if coulmn E
showed "Renewal", then a macro can trigger an action which can generate a
reminder e-mail to respective client in accordance with the e-mail address in
column F. In the reminder e-mail, it should contain respective client's name,
account name, the expiry date and some standard wordings. Can it be done? If
yes, please kindly advise.

Thanks in advance