Question Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by tony hopkinson

and those sorts of things are outlook specific.
You'd have to get outlook to do it for you I should think.
Put the data in the email, and some VBA at the outlook end triggeered by a rule or filter maybe...

This discussion is closed to new replies.