BUG: XP_SENDMAIL Fails to Send Mail to Personal Distribution List
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)
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 0xp_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.
REFERENCESSQL Server 2000 Books Online: topics; "SQL Mail"; "Configuring Mail Profiles"; "How to set up SQLAgentMail"
sqlmail sql mail email DL group alias global address book
Article ID: 315666 - Last Review: 01/17/2015 05:19:11 - Revision: 3.2
- Microsoft SQL Server 2000 Standard Edition
- kbnosurvey kbarchive kbbug kbpending KB315666