December 7, 2012 at 2:21 pm
Okay, so i have a query that i run several times a day. After running the query i then analyse the contents and send personalized reminders to the relevant contacts. Is there a way to send a batch of emails out based on criteria?
December 7, 2012 at 2:23 pm
sure ; setting up database mail is very straightforward.
a query that uses an EXISTS clause can decide whether to send or not.
from there, you need to decide if it's one email with everyone CC'd or BCC'd, or an individual email for each person.
Lowell
December 7, 2012 at 3:11 pm
Wow! quick reply. This sounds promising, thanks. So i have several fields including: Ticket#, Assignee, Sched End Date, Sched Close date. I want to use the assignee user id as the destination, and then List the tickets details (ticket # etc) within the email, and all of these details would be different per entry. Does all of this still sound doable? I've only had a small amount of sql training, so pardon my stupidity 🙁
December 12, 2012 at 3:38 pm
I think you can adapt this to work for you:
EXEC msdb.dbo.sp_send_dbmail
@profile_name='<the name of the profile you created in Database Mail>',
@recipients='<10 digit cell phone number>@txt.att.net;emailName@emailServiceProvider.com',
@subject='<any printable characters>',
@body='<any printable characters>'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply