xp_startmail and switching profiles

• uday

  SSChasing Mays

  Points: 633

  More actions

  May 13, 2002 at 10:54 pm

  #78749

  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.

  Regards

  Uday

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 14, 2002 at 5:43 am

  #429093

  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)