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

By Samal Iur ·

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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Doubt you can with sendmail as it's generic

by Tony Hopkinson In reply to How to add user propertie ...

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...

Related Discussions

Related Forums