Microsoft KB Archive/315666

= BUG: XP_SENDMAIL Fails to Send Mail to Personal Distribution List =

Article ID: 315666

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q315666



BUG #: 351475 (SHILOH_BUGS)



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.