Post reply

Overcome CDOSYS mailing limitation ?

  • 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

  • May 17, 2005 at 9:37 am

    #559304

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

  • May 18, 2005 at 12:08 am

    #559468

    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

  • May 18, 2005 at 12:25 am

    #559469

    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

  • May 18, 2005 at 11:12 am

    #559663

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

    Steve

  • May 18, 2005 at 10:32 pm

    #559770

    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

  • May 18, 2005 at 11:12 pm

    #559772

    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

  • May 18, 2005 at 11:34 pm

    #559773

    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

  • May 18, 2005 at 11:38 pm

    #559774

    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

  • May 19, 2005 at 12:17 am

    #559780

    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

     

  • May 19, 2005 at 12:17 am

    #559779

    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

     

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

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