Many Thanks to you. In order to achieve the results, use the below T-SQL query:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Profile Name',

@recipients=@cs_application_email,

@copy_recipients ='EMail addresses to be included in cc',

@blind_copy_recipients='EMail addresses to be included in bcc',

@sensitivity ='High/Normal/Low'

@subject ='Subject Of The EMail',

@body = @query,

@body_format = 'HTML' ;