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.

You rated this post out of 5. Change rating

2007-10-02 (first published: )

23,780 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Error in SQL Server Management Studio launcher

By Bcastro

Guys, good night! I have a situation in my SQL Server Management Studio where...

Just upgraded SSRS from 2016 to 2022

By LearningDBA

I just upgraded SSRS from 2016 to 2022. This is my first time doing...

Weekly sales report

By mailramk

I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers