xp_sendmail

[Matias]

Hi
can the receiver list (xp_sendmail parameter) be a query. Becuase i must to concatenate. Thanks

you want to send mail to addresses that are contained in a table?

@recipients = 'email1@here.com;email2@here.com'

just read the email addresses into a variable and seperate them with semicolons. you can do this in a temp table or use a cursor to keep appending a variable with the next email address. (watch the size here)

only other thing your question might be is if you can send a query and that answer is also yes.

@query = 'select * from sysobjects'

bol has a very detailed outline of all xp_sendmail parameters

------------
Matias at 3/14/00 10:04:14 PM

Hi
can the receiver list (xp_sendmail parameter) be a query. Becuase i must to concatenate. Thanks