EXECUTE msdb.dbo.sp_send_dbmail 
    @profile_name = 'SomeProfile'
,   @recipients = 'someone@somewhere.com'
,   @subject = 'Email Test'
,   @body = 'Email Test'

CREATE TABLE dbo.FOO
(
Accountid int, customer_name varchar(50), [order] varchar(50), quantity int, email varchar(50)
)
GO
CREATE TRIGGER dbo.FOO_update 
   ON  dbo.FOO 
   AFTER UPDATE
AS 
BEGIN
    SET NOCOUNT ON;

    -- Insert statements for trigger here
    SELECT I.orders, D.orders, I.email
    FROM
        INSERTED I
        INNER JOIN
            DELETED D
            ON D.accountid = I.accountid
END
GO
INSERT INTO
    foo
SELECT
    1 as accountID
,   'bob' AS customer
,   'start' AS orders
,   50 AS qty
,   'bob@your.uncle'

orders	orders	email
step2	start	bob@your.uncle

UPDATE
    FOO
SET
    orders = 'step2'
WHERE
    accountID = 1

DECLARE @body varchar(255), @recipients varchar(50)
SELECT
    @recipients = I.email
,   @body = 'Your order is now in a status of ' + I.[order]
FROM
    INSERTED I

-- create 2 new entities
INSERT INTO
    foo
SELECT
    2 as accountID
,   'robert' AS customer
,   'start' AS orders
,   50 AS qty
,   'robert@your.uncle'
UNION ALL
SELECT
    3 as accountID
,   'alice' AS customer
,   'start' AS orders
,   50 AS qty
,   'alice@your.aunt'

-- Perform a mass update
UPDATE
    foo
SET
   orders = 'step 3'

orders	orders	email
step 3	start	alice@your.aunt
step 3	start	robert@your.uncle
step 3	step2	bob@your.uncle