Kunal Das


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.

2005-02-18 (first published: )

23,517 reads

Blogs

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Loading large JSON file into a Data Table to Bulk Copy into SQL Server Table

By sadie

We have a JSON file with 10M records to bulk copy load into a...

Help with OPENJSON for Google Maps API data

By tacy.highland

Hello, I'm a newbie when it comes to JSON so when I started down...

pivot multiple columns and transpose to same row sql server

By sugaz007

I have a table like below: CREATE TABLE #Test (Category_ID INT, [Type] VARCHAR(2),Student_ID INT,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers