Hello experts, I would like to send an email notification to an employee when their car mileage has been approved, but I don't know if this can be done using a trigger.
I have a table CAR_MILEAGE_CLAIM and when the field MGR_APPROVED is updated to 'Yes' i would like to send an email notification to the employee, the email address is in the field EMPLOYEE_EMAIL
Here's what I'd like the email to be: (microsoft outlook 2000)
Subject: Car Mileage Confirmation & Date
Body: I can add blurb later