Microsoft small business knowledge base

Article ID: 315666 - Last Review: January 17, 2015 - Revision: 3.2

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)

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"

  • Microsoft SQL Server 2000 Standard Edition
kbnosurvey kbarchive kbbug kbpending KB315666
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support