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
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 351475 (SHILOH_BUGS)
Expand all | Collapse all

On This Page


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


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


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.


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


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


Article ID: 315666 - Last Review: January 17, 2015 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
kbnosurvey kbarchive kbbug kbpending KB315666

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