Post reply

send mail in html format

  • November 18, 2008 at 8:47 pm

    #127731

    How can i send email in html format using send mail task of SSIS?

  • November 19, 2008 at 7:20 am

    #900506

    Send Mail Task user interface doesn't support HTML message specification. However you can create a script, which uses the same functionality that the Send Mail Task is based on. Check this sample for ideas how to setup the script. Check MSDN documentation how to include HTML message.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • November 20, 2008 at 2:07 am

    #900920

    nplinares (11/18/2008)

    How can i send email in html format using send mail task of SSIS?

    1. create a mail format

    2. save its html content in a table with the desired column size. and create the labels for the required dynamic fields

    3. at the time of fetching, fetch the format in a variable , replace the dynamic labels with the required information

    4. send th mail

    done it via stored procedure

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

Viewing 3 posts - 1 through 2 (of 2 total)

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