Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Setting "Importance/Priority" of an email message using xp_sendmail?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-12 : 06:55:03
Suhas writes "Hello,

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"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2003-05-12 : 10:17:22
I don't think there is a way to do it specifically in sendmail, but you may be able to set it for the mail profile. Log on to the server with the account used by SQL Mail, open up Outlook, and find the option to send all mail using this priority. I don't have access to Outlook anymore, but I'm curious as to whether or not this works for you. Please post your results.

Jeff Banschbach, MCDBA
Go to Top of Page
   

- Advertisement -