How to add user properties to a message while using sp_send_dbmail? - TechRepublic
Question
July 27, 2011 at 04:06 AM
samal iur

How to add user properties to a message while using sp_send_dbmail?

by samal iur . Updated 14 years, 11 months ago

Hello,

I need to use sp_send_dbmail from SQL server 2008 r2 to send messages from SQL server but I would like to add to these messages some user properties like “CotationNumber”, “CotationDate”, something like what is possible while using outlook vb inspectors:

NewMsg.UserProperties.Add “CotNum”, olText

Is it possible? How to do it?

Thank you in advance.
SI

This discussion is locked

All Comments