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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-31 : 22:42:51
|
| Fabio writes "Hello SQL Team, I read your "Sending SMTP Mail using a Stored Procedure" article. Today I use a stored procedure to send e-mails via SQL server almost identical the procedure decribed in the article. This procedure works fine for text e-mails, but I coudn't make it work for HTML e-mails. I tryed to use this :exec @hr = sp_OACreate_jmail @object OUT exec @hr = sp_OASetProperty @object, 'GetMessageBodyFromURL', 'http://mila/selector/fabio/envia_mala_direta_aberil.asp?nome=''Fabio Rosa''' And several variants of this code to send an e-mail based on an asp code without sucess. Could you help me ? I'm using SQL Server 2000 and JMail 4.3Personal. Thanks in advance for your help. Fabio Rosa" |
|
|
|
|
|
SMTP Mail