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-06-06 : 12:22:42
|
| Dhanraj writes "Hi,I want to send mail through SQL Server .Please suggest the way out.I don't want to use the extended stored procedure which given by the SQL Server because if you use this procedure u should configure the Microsoft outlook express on ur server.Where u can configure one default client account . You should open the outlook express constantly if u want to use this facility that is not possible for me.It wil only send mail to Mapi and after that it will send mail through the outlook express.I already use the "CDONTS.Newmail" object also but i face problem for Message Body (I can only send message upto 255 chars). But my requirement is more that that(above 5000 chars).Input parameter is accept 8000 char but when u actuall send the message it will truncate the data and only send maximum 255 chars.Please give me the solutions for it.Thanks in advance..By reply me on my email Id dhanraj@studentsguild.com" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-06 : 20:10:43
|
| [url]http://sqldev.net/xp/xpsmtp.htm[/url]XPSMTPCracking extended proc, just using SMTP , no client requiredMessage can also be read from a file to bypass 8000 (varchar)and 4000 (nvarchar) @message param size limit. Supports HTMLmail and works on all server flavours of SQL7 and 2000. Knowa lot of people who use this and it comes highly recomended.HTHJasper Smith |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-06-06 : 20:14:32
|
quote:
I want to send mail through SQL Server .Please suggest the way out.
Down the hall, through reception, out the front door. See ya!Damian |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-06-06 : 20:32:18
|
| LOL - Damian, ...you must be tired!--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Sending mail through SQL Server.(Body text sholud be 8000 chars)