Do not trust xp_sendmail in a trigger. We (County of Marin) have use Exchange with an Outlook client and have had trouble from time to time with email. ...