Post reply

xp_sendmail to send email with HIGH Importance in Outlook

  • June 24, 2004 at 4:26 am

    #87708

    Hi,

    Does anybody know if it's possible to configure xp_sendmail to send email with HIGH IMPORTANCE flag set with Outlook as the email client?

    I can't see how to do this in BOL.

    Thanks in advance.

    Regards,

    Andy

  • June 24, 2004 at 6:17 am

    #511755

    Can't do from SQL with xp_Sendmail.

    But maybe you can configure a rule from Outlook to send those mails with high importance, filtering by the subject, the sender of anything...

  • June 25, 2004 at 4:58 am

    #511929

    I've doing done digging and I think the only way it can be done is by using CDONTS.dll with sp_OACreate.

    I'll post the script here when I figure out how to do this.

  • June 25, 2004 at 10:04 am

    #511993

    If you use CDONTS, You can set the importance like this

    EXEC sp_OASetProperty      @iMsg, 'Importance', 2

    Hopr this helps!!!

     

  • June 28, 2004 at 6:48 am

    #512151

    ok thanks for the tip.

  • June 30, 2004 at 8:59 am

    #512682

    Anyone know how to set IMPORTANCE flag using CDOSYS instead?

    EXEC sp_OASetProperty @iMsg, 'Importance', 2 does not work.

    Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

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