Try using a trigger, although you probably do not want to send an email directly from a trigger. 
Create an insert trigger, when it fires, capture the relevant information for a new employee, and insert that into an "email queue" table.  Set up a SQL job that runs on a schedule that looks for new rows in this table, and sends the email if it finds one. 

An update trigger can be created to do the same thing for the terminated employees.