Overcome CDOSYS mailing limitation ?

Question

Post reply

Overcome CDOSYS mailing limitation ?

Hemant Kumar

Ten Centuries

Points: 1063
More actions
May 13, 2005 at 6:05 am

#88996

Hai Guys,
I 'm able to send mails from SQL Server using CDOSYS.DLL, but the limitation we have with this is that the maximum characters in the Body of the mail could only be 8000 characters. I would like to overcome this limitation.
Regards,
Hemant
May 16, 2005 at 8:00 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Martin D. Cymerman SSCrazy Points: 2079 More actions · Answer 1

Martin D. Cymerman

SSCrazy

Points: 2079

May 17, 2005 at 9:37 am

#559304

Check out http://www.cdolive.com/kb.htm

Hemant Kumar Ten Centuries Points: 1063 More actions · Answer 2

Hai Martin,

Thanx for the site info, but I didn't find anything related to my problem (overcoming that 8000 characters limitations). Please let me know if you come across solution to this

Regards,

Hemant

philcart SSC-Forever Points: 47796 More actions · Answer 3

We use a combination of sp_makewebtask and xp_smtp_sendmail to acheive this. Eliminating any reliance on CDO and/or SQL Mail.

sp_Makewebtask generates a HTML file which is then used as the email body in xp_smtp_sendmail.

--------------------
Colt 45 - the original point and click interface

hoo-t SSChampion Points: 12713 More actions · Answer 4

You could send your text as an attachment to overcome the 8000 char limitation.

Steve

Hemant Kumar Ten Centuries Points: 1063 More actions · Answer 5

Hai Steve,

Thats a good point steve but I have been asked to send newsletters which cannot be an attachement . It should get displayed as a normal HTML page. Hope you got my point

Regards,

Hemant

philcart SSC-Forever Points: 47796 More actions · Answer 6

We use the method I've described to send out a couple of form letters that are formatted for HTML.

--------------------
Colt 45 - the original point and click interface

Hemant Kumar Ten Centuries Points: 1063 More actions · Answer 7

Yes Phill,

I looked into that sp_Makewebtask and that was awesome information for me to send the newsletter in a more confortable way but buddy I was not able to find that extended stored procedure xp_smtp_sendmail. Can u please help me in this? and more importantly does this overcome that 8000 character barrier?

Thanx and Regards,

Hemant

philcart SSC-Forever Points: 47796 More actions · Answer 8

xp_smtp_sendmail comes from http://www.sqldev.net

It's a very useful replacement for SQL Mail.

--------------------
Colt 45 - the original point and click interface

Hemant Kumar Ten Centuries Points: 1063 More actions · Answer 9

Yeah Phill,

I visited sqldev and found in their log that they have addressed this limitation That was awesome and a great relief . Thank u once again

Regards,

Hemant

Hemant Kumar Ten Centuries Points: 1063 More actions · Answer 10

Yeah Phill,

I visited sqldev and found in their log that they have addressed this limitation That was awesome and a great relief . Thank u once again

Regards,

Hemant