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 - 2000-11-29 : 09:37:51
|
Gerald writes "Hi,
I wanted to use SQLMAIL to send mail in a stored procedure but I discovered that it's impossible to send mail in HTML format. So, I decided to use a COM Component (CDONTS.NewMail) with sp_OACreate. It works fine, the problem (of course there is a problem :) ) is : SQL Server use the runtime VB to call the Object and convert varchar, text to string. This string is with 255 characters or less !!!
What can I say with 255 characters ???
SOmebody has an idea ?
Thanks in advance.
Best Regards.
Gerald" |
|
|
|
|
|
Using a COM Component to send mail