Send Email in SQL

Question

Dear,

i created a trigger on CustomerCall when call inserted & Assign to particular user i want to send email.

Below is the working trigger only how to get the Assign user email address from User Table

User-Table

us_No

Us_Name

Us_Password

Us_Email

I want when the customer call assign to particular user take that email address and put it in below trigger.

alter TRIGGER CallInserted

ON [dbo].[CustomerCall]

FOR INSERT

AS

BEGIN

SET NOCOUNT ON;

IF EXISTS (SELECT * FROM inserted)

BEGIN

EXEC msdb.dbo.sp_send_dbmail

// here how to get receipent email from User table

@recipients = 'recipients',

@profile_name = 'SendEmailCM',

@subject = 'Notification',

@body_format = 'html',

@body = 'body'

END

END

GO