SQL Email Trigger Configuration

I need help configuring an email trigger based on an SQL event using SMTP. Our IT Services has set up email service using SMTP2GO and has sent successful test emails. I know how to write queries (I typically run queries in Excel using database connection)... (Budget: $250 - $750 USD, Jobs: Database Administration, Database Development, Database Management, Database Programming, SMTP, SQL)