xp_startmail and switching profiles

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Kunal Das » xp_startmail and switching profiles

xp_startmail and switching profiles

Rate Topic

Display Mode

Topic Options

Author

Message

uday

Posted Monday, May 13, 2002 10:54 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:12 AM
Points: 37, Visits: 32

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

Post #4216

Antares686

Posted Tuesday, May 14, 2002 5:43 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

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)

Post #33711

« Prev Topic | Next Topic »

Permissions