sql server programming: sql mail -- sql server programming

Re: sql mail

Michiel Wories [MS]
9/24/2003 7:22:34 AM

sql server programming:

See http://support.microsoft.com/?id=315886 Q5 and Q6.

--
Michiel Wories, SQL Server PM

This posting is provided "AS IS" with no warranties, and confers no rights.
---
[quoted text, click to view]

sql mail

drishtik
9/24/2003 11:28:07 PM

hi
i am making an car rental application.
i want to use xp_sendmail to send a mail to my customer informing him that
the car has been booked succesfully and
his booking id .

when i use

exec master..xp_sendmail @recipients='rajnish@hotmail.com',
@subject='test1000',@message='test message1000'

i want it doesnt get delivered to the email addy 'rajnish@hotmail.com'

but when i say xp_readmail
i can see all my msgs there.
how do i send all msgs to rajnish@hotmail.com ??
i am using dotnet 2003 on win server 2003
and i have ms outlook as my default mail client
and have configured a profile called sa which i use to start sql mail
thank you for your help