How To: Email Trigger

[ntbuddy]

When I post a new record into a table how can I get a trigger to fire and send an e-mail to someone based on what department the record belonged to? The system already is setup for maintenance to send e-mail so I know that part is set up. Thanks, John

 

[ClaireHCM]

Where you are going to get the name or email add of the recipient?
Is that table has any connection of the table which youa re going to insert?

You can create a trigger on the table where you are going to insert,then pick up the name or email from some table then use extended stored procedure {master..xp_sendmail} to exeucute this task