SQL Server - How to send email using store procedure

Hi friends,

I have to send an email using sql. please refer to the below requirements.

1.same like we sending new email but i want the code in sql.
2.From (this is constant email only xxxx@mail.com)
3.To (the id's are store in test table)
4.CC (the id's are store in test table)
5.BCC (the id's are store in test table)
4.subject 

I want to send out the email who are not started and Partially. so i have to use if loop for each status.

if (status = not started)
{ 

}
if (status = partially)
{
}

so for particular status i have to send email. i have these data in my test table. please provide me the code to send with above conditions by using sql. Thanks in advance

You are looking for xp_sendmail

yes