Kunal Das

SQLServerCentral Article

Using Xp_sendmail With the Recipients Generated From a Query

Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.

2007-10-02 (first published: )

23,709 reads


Goal Progress for Nov 2022


I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?


Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Daily Coping 2 Dec 2022


Today’s coping tip is to enjoy new music today: play, sing, dance, or listen....

Read the latest Blogs


Dynamically select tables for SSAS processing

By Chrissy321

Hello Folks, Analysis Server I am currently processing my full database via SQL...

Query with query ID (nnn) is not found in the query store

By MMartin1

Hi: I ran into an issue when I looked to try to manually force...

SQL Saturday MN #1028 on December 3rd, 2022 (Virtual Event)

By Jeff Moden

This event is "tomorrow" on Saturday, December the 3rd. Here's the link for their...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers