Alert, Reminder
 

I have created an excel sheet which has names and adresses. Within the
datasheet, I have an alert system, which tells me when someone has paid his
rent by a certain date. If the person does not pay his/her rent
outside the due date the cell will go red. What I want to do is:

1. Pick up the name and address or email address from the excel sheet and
send a reminder to the tenant that he/she has not paid his/her rent by the
due date. This reminder can be either a letter or an email.

So essentially once the warning date comes up, I want to click the alert cell
which will create and print the reminder or send an email.

Any help would be appeciated.