Your question, your audience. Choose who sees your identity—and your question—with question security.
I would like the @Subject to be the SupplierName and BankAccount that has been amended.
CREATE TRIGGER trNAME ON ApSupplier AFTER UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here IF UPDATE (BankAccount) BEGIN EXEC msdb.dbo.sp_send_dbmail @profile_name = 'TEST', @recipients = "firstname.lastname@example.org", @body = "TEST", @subject = "SupplierName +BankAccount" END END