DECLARE @tableHTML			VARCHAR(MAX)
	DECLARE @tEmailList			VARCHAR(MAX)
	DECLARE @tProfile			VARCHAR(128)
	DECLARE @tEmailSubject		VARCHAR(2048)

	SELECT 
		@tEmailList = email_address
		,@tEmailSubject = CAST(@@SERVERNAME AS VARCHAR(128)) + ' - DB_Admin.dbo.usp_sel_InfoOS'
		,@tableHTML = N'<H2>Database Report for Server: ' 
			+ @@SERVERNAME + '</H2>' 
			+ N'<table border="1">' 
			+ N'<tr>
					<th>Host Name</th>
					<th>OS Name</th>'
			+ CAST
				(
					(
					SELECT 
						td = [HostName]
						,''
						,td = [OSName]
						,''
					FROM [DB_Admin].[dbo].[tbl_InfoOS]
					FOR XML PATH('tr'), TYPE) AS NVARCHAR(MAX)) 
			+ N'</table>
This was generated by the <i>DB_Admin.dbo.usp_sel_InfoOS</i> Stored Procedure
'
	FROM msdb.dbo.sysoperators
	WHERE [name] = 'DBA'

	EXEC msdb.dbo.sp_send_dbmail
		@profile_name = @tProfile
		,@recipients = @tEmailList
		,@subject = @tEmailSubject
		,@body_format = 'html'
		,@body = @tableHTML