BUG: XP_SENDMAIL Fails to Send Mail to Personal Distribution List

Article translations Article translations
Article ID: 315666 - View products that this article applies to.
This article was previously published under Q315666
BUG #: 351475 (SHILOH_BUGS)
Expand all | Collapse all

On This Page

SYMPTOMS

When you use the xp_sendmail system extended stored procedure to distribute mail to a personal distribution list, the process may fail with the following error message:
Server: Msg 18031, Level 16, State 1, Line 0
xp_sendmail: could not resolve recipient
					

CAUSE

The xp_sendmail system extended stored procedure may not be able to resolve a personal distribution list.

WORKAROUND

To work around the problem you can use either of these methods:

  • Use SQLAgentMail to distribute mail to personal distribution lists. -or-

  • Itemize the individual recipients of the personal distribution list in the @recipients parameter of the xp_sendmail system extended stored procedure.

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000.

REFERENCES

SQL Server 2000 Books Online: topics; "SQL Mail"; "Configuring Mail Profiles"; "How to set up SQLAgentMail"

Properties

Article ID: 315666 - Last Review: October 3, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbpending KB315666

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com