Please provide scripts for all tables/triggers involved. I am also a bit unclear - are you trying to actually SEND the email from a trigger or queue up a SSB message that will be used to asynchronously send the email?