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)
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 0xp_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.

REFERENCES

SQL 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
Properties

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
Feedback