Article ID: 315666 - View products that this article applies to.
This article was previously published under Q315666
BUG #: 351475 (SHILOH_BUGS)
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:
Microsoft has confirmed that this is a problem in SQL Server 2000.
REFERENCESSQL Server 2000 Books Online: topics; "SQL Mail"; "Configuring Mail Profiles"; "How to set up SQLAgentMail"