Post reply

Emailing through SQL to show HTML table

  • November 8, 2005 at 10:16 am

    #166625

    i currently use xp_smtp_sendmail to send notifications. does anyone know how to make the results from a query  show in the email in the form of a table.

    i tried putting;

    <br>Please address with the individual agents.<br><table border = 1><tr><td><b>Agent Username</b></td></tr><tr><td>rgrisham</td></tr><tr><td></table>

    in the body but that did not work. any ideas?

  • November 11, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • November 18, 2005 at 1:58 pm

    #604741

    Hi,

    have you tried to create a HTML document( all tags html/head/body/table/...) and store it to sting variable. You can then use this variable to pass it as a HTML body

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

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