SQL数据库邮件 发HTML格式的邮件??
用如下存储过程发送邮件,但邮箱里面收到的还是HTML的源代码,请高手指点,要在邮箱里收到显示表格的形式。
(
邮箱收到:
<H1>Work Order Report</H1><table border="1"><tr><th>Work Order ID</th><th>Product ID</th><th>Name</th><th>Order Qty</th><th>Due Date</th><th>Expected Revenue</th></tr><tr><td>YTP41102435 </td><td>订单取消</td><td>T8600961553175</td><td>YUUZM64</td><td>2011-05-16T14:53:00</td><td>2011-05-16T22:00:00</td></tr><tr><td>YIS41107830 </td><td>订单取消</td><td>T8600961555157</td><td>YISZYHN</td><td>2011-05-24T08:35:00</td><td>2011-05-24T11:00:00</td></tr><tr><td>YIS41107639 </td><td>订单取消
)
ALTER proc [dbo].[sp_send_yjMail]
AS
BEGIN
DECLARE @tableHTML nvarchar(max)
DECLARE @Title nvarchar(max)
SET @Title=’JIT时间控制分析'
SET @tableHTML =
N'<H1>Work Order Report</H1>' +
N'<table border="1">' +
N'<tr><th>Work Order ID</th><th>Product ID</th>' +
N'<th>Name</th><th>Order Qty</th><th>Due Date</th>' +
N'<th>Expected Revenue</th></tr>' +
CAST ( ( SELECT td = OrderNo, '',
td = Status, '',
td = CustomsPackingNo, '',
td = CustomerID, '',
td = CreateTime, '',
td = YunjiaoTime
FROM view_Rabi
WHERE YunjiaoTime IS NOT NULL AND YunjiaoTime<=GETDATE() and Status<>'订单完成'
ORDER BY OrderNo DESC
FOR XML PATH('tr'), TYPE
) AS NVARCHAR(MAX) ) +
N'</table>' ;
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'guoqiang.chen@giessen.com.cn',
@body = @tableHTML,
@subject = @Title
END