Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sending Emails From SQL Server Expand / Collapse
Author
Message
Posted Friday, December 7, 2012 2:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 3, 2013 7:23 AM
Points: 2, Visits: 6
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?
Post #1394248
Posted Friday, December 7, 2012 2:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:55 AM
Points: 12,902, Visits: 32,141
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1394251
Posted Friday, December 7, 2012 3:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 3, 2013 7:23 AM
Points: 2, Visits: 6
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
Post #1394263
Posted Wednesday, December 12, 2012 3:38 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 21, 2014 10:47 AM
Points: 258, Visits: 1,093
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>'

Post #1395907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse