May 8, 2003 at 12:07 pm
Hello Everyone,
I was wondering if there is a way to set the "Importance"
or "Priority" of an email message when using xp_sendmail
(MS SQL 7.0 SP4). I looked at the help section, but could
not find an Argument I could specify to do this.
Basically, we are using Microsoft Outlook and we want to
see the 'red exclamation (!)' symbol next to some of the
email messages that are being generated using xp_sendmail.
Thanks for your help.
Suhas
May 8, 2003 at 1:33 pm
I looked at this for a while and I don't believe that MS provided that functionality with the xp_sendmail functionality. If you find out different I would love to hear about it.
You could do something like specifying "Important: " in the subject line and then have the customers interested in special message handling set up rules to deal with that appropriately. Cheesy I know but it does work.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 15, 2003 at 6:34 pm
You can set the default importance level in Outlook itself. I'm using Outlook 2000 and you can reach that setting by:
Tools menu
Options
E-mail Options button (on first tab - Preferences)
Advanced E-mail Options button
Set Importance drop-down list (choose High)
If you're not using Outlook 2000, the setting is most likely there somewhere within Outlook. Granted, any message then sent from Outlook (even interactively) will default to "High" importance.
Hope that helps.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply