Xp_sendmail

[tlaksh]

can i pass reciepient name in xp_sendmail procedure as a value from a variable instead of hardcoding the value

Thanks

Lakshmi

 

[tlbroadbent]

Yes. In T-SQl you would do the following assuming the variable name is @recpt.

xp_sendmail @recipients = @recpt,
@message = 'message',
@subject = 'subject',

In VB, ASP or other languages you need to evaluate the variable in your code before executing the query that executes xp_sendmail. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot