I actually figured it out a moment after posting. For anyone in a similar sitation I did the following:

DECLARE @tableHTMLA VARCHAR(MAX) ;

SET @tableHTMLA =

N'<H1>PLACE TABLE...

Now, I am new to SQL and in the phase of learning while doing. I am emailing results from a query via an HTML table generated by code much like...