SET NOCOUNT ON;
DECLARE @body nvarchar(max)

SET @body = N'
<style type=''text/css''>
	TABLE{border-width: 1px;border-style: solid;background-color: #E8E8E8; border-color: black;border-collapse: collapse;}
	TH{color:black; border-width: 1px;font-size: 11px; padding: 3px;border-style: solid;border-color: black;}
	TD{color:black; border-width: 1px;font-size: 11px; padding: 3px;border-style: solid;border-color: black;}
</style>' +
N'<h5> *** This is an automatic email, please do not reply *** </h5>' +
N'<table>' +
	N'<th> name </th> <th> is_disabled </th>' +
	CAST((select column_name AS 'td','' , column_name AS 'td' FROM table_name
	FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX)) +
N'</table>'

EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'dbmail',
	@recipients = 'test@email.com; noreply@email.com',
	@copy_recipients = 'ol_exec@email.com; ol_exec@email.com',
	@subject = 'This is an automatic email',
	@body = @body,
	@body_format ='HTML',
	@importance = 'High'