CDONTS-Sending HTML mail-8000 character limit

[Shane Porter]

Hi all,

I have seen a few messages about this in the archives, but none
provide a comprehensive answer.

Basically, I want to use CDONTS mail support from within SQL server to
send HTML formatted email that could potentially be longer than 8000
characters. (I have done it successfully with short HTML mails).

Is there any way to do this? If not, could anyone offer alternative
suggestions for implementing a mailing list to email addresses stored
in an SQL Server 2000 database table?

Thanks, in advance,
Shane.

[Charlie Yukio Nakagawa]

Shane,

In SQL 7.0, I created a sp that receives as parameters the body of the email
as a text parameter. Then, when setting the 'body' property of the
CDONST.NewMail object, I use this parameter. It works just fine. Like this:

CREATE PROCEDURE sp_SysEnviaEmail
@remetente text,
@destinatario text,
@assunto text,
@corpo text
......
EXEC @hr = sp_OACreate 'CDONTS.NewMail', @object OUT
EXEC @hr = sp_OASetProperty @object, 'From', @remetente
EXEC @hr = sp_OASetProperty @object, 'To', @destinatario
EXEC @hr = sp_OASetProperty @object, 'Subject', @assunto
EXEC @hr = sp_OASetProperty @object, 'Body', @corpo


--
---------------------------------------------
Charlie Yukio Nakagawa
Direct Talk - 3049-8421
---------------------------------------------

"Shane Porter" <shaneporter66@hotmail.com> escreveu na mensagem
news:b8b802e8.0307030549.105a20e7@posting.google.c om...

> Hi all,
>
> I have seen a few messages about this in the archives, but none
> provide a comprehensive answer.
>
> Basically, I want to use CDONTS mail support from within SQL server to
> send HTML formatted email that could potentially be longer than 8000
> characters. (I have done it successfully with short HTML mails).
>
> Is there any way to do this? If not, could anyone offer alternative
> suggestions for implementing a mailing list to email addresses stored
> in an SQL Server 2000 database table?
>
> Thanks, in advance,
> Shane.

[Shane Porter]

Hi Charlie,

thanks for the feedback, but I have a stored procedure like the one
you have posted. If I change the '@corpo'/body parameter data type to
text, the longest string I can send is 4000 characters.

<I need to be able to send _over_ 8000 characters>

Shane.

"Charlie Yukio Nakagawa" <charlie.nakagawa@uol.com.br> wrote in message news:<exu5M$ZQDHA.2480@tk2msftngp13.phx.gbl>...

> Shane,
>
> In SQL 7.0, I created a sp that receives as parameters the body of the email
> as a text parameter. Then, when setting the 'body' property of the
> CDONST.NewMail object, I use this parameter. It works just fine. Like this:
>
> CREATE PROCEDURE sp_SysEnviaEmail
> @remetente text,
> @destinatario text,
> @assunto text,
> @corpo text
> .....
> EXEC @hr = sp_OACreate 'CDONTS.NewMail', @object OUT
> EXEC @hr = sp_OASetProperty @object, 'From', @remetente
> EXEC @hr = sp_OASetProperty @object, 'To', @destinatario
> EXEC @hr = sp_OASetProperty @object, 'Subject', @assunto
> EXEC @hr = sp_OASetProperty @object, 'Body', @corpo
>
>
> --
> ---------------------------------------------
> Charlie Yukio Nakagawa
> Direct Talk - 3049-8421
> ---------------------------------------------
>
> "Shane Porter" <shaneporter66@hotmail.com> escreveu na mensagem
> news:b8b802e8.0307030549.105a20e7@posting.google.c om...

> > Hi all,
> >
> > I have seen a few messages about this in the archives, but none
> > provide a comprehensive answer.
> >
> > Basically, I want to use CDONTS mail support from within SQL server to
> > send HTML formatted email that could potentially be longer than 8000
> > characters. (I have done it successfully with short HTML mails).
> >
> > Is there any way to do this? If not, could anyone offer alternative
> > suggestions for implementing a mailing list to email addresses stored
> > in an SQL Server 2000 database table?
> >
> > Thanks, in advance,
> > Shane.

[Jose Hernandez]

Although not CDONTS [url]http://sqldev.net/xp/xpsmtp.htm[/url] has a messagefile
parameter that contains the message text in PlaintText or HTML with a max
file size of 64 KB

Jose

"Shane Porter" <shaneporter66@hotmail.com> wrote in message
news:b8b802e8.0307030549.105a20e7@posting.google.c om...

> Hi all,
>
> I have seen a few messages about this in the archives, but none
> provide a comprehensive answer.
>
> Basically, I want to use CDONTS mail support from within SQL server to
> send HTML formatted email that could potentially be longer than 8000
> characters. (I have done it successfully with short HTML mails).
>
> Is there any way to do this? If not, could anyone offer alternative
> suggestions for implementing a mailing list to email addresses stored
> in an SQL Server 2000 database table?
>
> Thanks, in advance,
> Shane.