sending multiple mails using select Query

0.00/5 (No votes)

See more:

I have got this by writing select From,To,Subject, Body from xyz. and for example it returned 20 records and i want to send mails. Is it possible directly ??? without using Cursor and all ??

Posted 10-Oct-13 22:36pm

deepakdynamite

Add a Solution

Comments

Thanks7872 11-Oct-13 4:39am

Get all the records in datatable. Loop through it,pass these values to the function which is supposed to send mail,that's it.

deepakdynamite 11-Oct-13 5:13am

Its a procedure which is used to send Email. and that cannot be called from function

Prasad Khandekar 11-Oct-13 5:24am

Hello Deepak,

Nope, you will have to use cursor. In case the email contents are same for every one then sp_send_dbmail can send same email to multiple recipients (http://technet.microsoft.com/en-us/library/ms190307.aspx).

Regards,

Mubin M. Shaikh 17-Oct-13 7:33am

Hi you can go for concatenation of you emails using looping and then pass them as parameter to function to send email at once.

you need to specify what exactly you need.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

OriginalGriff	80
Richard MacCutchan	50
k5054	20
Michel A. Chevrier	20
KarstenK	10

Pete O'Hanlon	265
Richard MacCutchan	260
Dave Kreskowiak	175
OriginalGriff	170
merano99	60