Post reply

Sending Emails From SQL Server

  • December 7, 2012 at 2:21 pm

    #99792

    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

    #1566774

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 7, 2012 at 3:11 pm

    #1566785

    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

    #1568088

    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