Post reply

DTS: Send Mail Task

  • October 31, 2006 at 3:38 am

    #71043

    I've setup a DTS package using the DTS Send Mail task in SQL Server 2000. I was wondering if there is any way to change the font type and size with regards to the information which is displayed in the Message text area. I've tried to use the following HTML but it just comes through as text: <font size=14 face=arial> this is a test message.

  • November 1, 2006 at 6:25 am

    #669186

    I've done somthing similar using VBA in MS Access.  To do this in a DTS package you'd have to create an active-x task to replace the sendmail portion of your package.  Using VB you'd be able to access the Font setting for a mail object.

    Regards,
    Matt

  • November 1, 2006 at 6:45 am

    #669192

    Thanks!

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

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