Post reply

looping emails

  • July 20, 2010 at 6:58 am

    #224994

    I need to send emails to locations which come up in the query

    SELECT [LOCATION],[CUSTOMER],[ACCOUNT],[CUSTOMER_NAME],[PHONE]

    FROM [vw_PAST_DUE_LESSONS_EZPAY]' ,

    each location shud get there own information emailed to them

    i have a temp table which i have created that stores the email addresses

    am reallly reallly new at this

  • July 20, 2010 at 7:26 am

    #1195498

    Do you have DBMail set up on your server?

    If you do then take a look at the stored procedure sp_send_dbmail in BOL. You may need your DBA to grant permissions for you to be able to use this.

    Rich

    Hope this helps,
    Rich

    [p]
    [/p]

  • July 20, 2010 at 7:28 am

    #1195500

    yeah i have db mail set up on here

    and i have permission to do this

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply