xp_startmail and switching profiles

  • Guys!

    I'm using SQL Mail to send out Emails to Customers re: outstanding Invoices. I also use SQL Mail on the same box to send out emails to our Sales Reps with summaries of outstanding invoices. Now, I've set up multiple outlook profiles on the server. I tried using

    xp_startmail @user = 'CreditControlDept'

    xp_sendmail .... (to customers)

    xp_stopmail @user = 'CreditControlDept'

    xp_startmail @user = 'InvoiceTracker'

    xp_sendmail...(to internal sales reps)

    xp_stopmail @user = 'InvoiceTracker'

    DOES NOT WORK!!! the profile does'nt switch at all. SQL Mail sends out all the emails using the profile that it started with. How can I use xp_startmail and xp_stopmail to switch between different user profiles.



  • Please do not cross post, see replies at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4217&FORUM_ID=5&CAT_ID=1&Topic_Title=xp%5Fstartmail+and+switching+profiles&Forum_Title=Administration

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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