HTML MAIL USING SQL PROCEDURE

--- EXEC html_mail      
       
Alter procedure html_mail       
AS       
BEGIN       
       
DECLARE @tableHTML1  as NVARCHAR(MAX),         
 @subjec1 as varchar(50)         
         
Select @subjec1 = 'EMPLOYEE DETAILS MAIL'     
                   
Set @tableHTML1 =                                    
N'

Dear Sir,

' +
N'' +                               
    N' ' +                                 
   
CAST ( ( SELECT distinct  td = a.emp_code,'',                                
                          td = a.emp_name,'',
                          td = a.emp_add,''
         
                        FROM EMP_DETAILS as a                               
                                                 
                    FOR XML PATH('tr'), TYPE  
                               
    ) AS NVARCHAR(MAX) ) +
            
    N'

EMPLOYEE CODE	EMPLOYEE NAME	ADDRESS

' +                      
    N'
' +                               
  N'

' +                                
 N'

With Best Regards,

' +                               
 N'

Kohinoor Steel (P) Ltd.

'+           
 N'' +                                              
 N'

' +                                
 N'

*******This is an automated message. Please do not reply*******

'                           
                             
                                   
                                    
EXEC msdb.dbo.sp_send_dbmail       
    @profile_name='ERP',                                  
    @recipients='arkaa4@gmail.com',
    --@copy_recipients = 'priyanka@kohinoorindia.in;avinash@kohinoorsteel.com',                           
    --@blind_copy_recipients = 'erp@kohinoorindia.in',                                   
    @subject =@subjec1,   
    @body = @tableHTML1,                                  
    @body_format = 'HTML'
     
 end      
---------------------------------------------------------------------       
--- EXEC html_mail