Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TODD RAYMOND
Starting Member
1 Post |
 Posted - 2010-04-09 : 14:10:43
|
| The Problem is that when executing the code below, the resulting email body looks like this:Click here to complete the form... <http://www.yahoo.com> What I want is the entire sentence to be the link without the url showing.exec master.dbo.xp_smtp_sendmail @TO = 'Todd.Raymond@p2psolutions.com', --@tempEmail, @FROM = 'Todd.Raymond@p2psolutions.com', @SUBJECT = 'test', @BODY = '<a href="http://www.yahoo.com">Click here to complete the form...</a>', @type = 'text/html', @server = 'mail.spendtronics.com' |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-24 : 03:17:10
|
| hi,I dont find the procedure master.dbo.xp_smtp_sendmail in my SQL 2000 or 2005. which version you are using?Code you have written is seems to be correct.I am using the usp_send_cdosysmail for sending mails, works fine.exec master..usp_send_cdosysmail @from ='Todd.Raymond@p2psolutions.com', @to='Todd.Raymond@p2psolutions.com', @subject ='test', @body = '<a href="http://www.yahoo.com">Click here to complete the form...</a>', @smtpserver ='mail.spendtronics.com', -- or your server IP address. @bodytype ='HTMLBody'Regards,Sathieshkumar. R |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-04-26 : 13:55:26
|
| It was actually a third party stored proc (free) at SQLDEV.net. I used it in SQL2000 but not in SQL2005. I can't find a download anymore.Terry-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher |
|
|
|
|
|
|
|
|
HTML with xp_smtp_sendmail