I have a database, which keeps track of peoples training dates, they have to complete the training yearly. I can run reports to see who is overdue, or comming due in 60 days.
I would like to be able to run a report like this, however, I would like it to have a spot to click next to the users information, so I could email him/her, using the email address for that person, and in the email I would like to have text already typed in.
I would like the text already typed in the email to use the date and name from the database as part of it.
Ex.
(nameFromDatabase),
Your last completion of Blah Training was on (dateFromDatabase).
I need you to see me ASAP to re-accomplish this training.
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
I have had a little computer programming in college however, I am not an expert. So I will be grateful for any help, but the more specific would be best. Thanks.