sp_send_dbmail as HTML Email
Database
2
Posts
1
Posters
0
Views
1
Watching
-
I took the books online sample and modified it with my data. When I run the query it sends the email, with the Header, and nothing else. The Table data never shows. Here is the code I used; USE NMS_RT DECLARE @tableHTML NVARCHAR(MAX) ; SET @tableHTML = N'
MCP Alarms for previous 24 Hours
' + N'
-
I took the books online sample and modified it with my data. When I run the query it sends the email, with the Header, and nothing else. The Table data never shows. Here is the code I used; USE NMS_RT DECLARE @tableHTML NVARCHAR(MAX) ; SET @tableHTML = N'
MCP Alarms for previous 24 Hours
' + N'
The answer was a simple. I missed a double quote in this field; N''