Try something like this, replacing the query:

DECLARE @tableHTML NVARCHAR(MAX) ;

DECLARE @sqlquery VARCHAR(MAX)

SET @tableHTML =

N'<H1>PLACE TABLE HEADER HERE</H1>' +

N'<table border="1">' +

N'<tr><th>COLUMN 1 HEADER</th>' +

N'<th>COLUMN 2 HEADER</th>' +

N'<th>COLUMN 3 HEADER</th> </tr>' +

--place sql here formatted like this

CAST ( ( SELECT td = COLUMN1 0 END), ' ',

td = COLUMN2, ' ',

td = COLUMN3, ' '

FROM DATABASE_Name..Table_Name

FOR XML PATH('tr'), TYPE

) AS NVARCHAR(MAX) ) +

N'</table>' ;

EXEC msdb.dbo.sp_send_dbmail @recipients='Someone@yahoo.com',

@subject = 'Place Subject Here',

@body = @tableHTML,

@body_format = 'HTML',

@query = @sqlquery