BUG: XP_SENDMAIL Fails to Send Mail to Personal Distribution List

Article translations Article translations
Article ID: 315666 - View products that this article applies to.
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)
Expand all | Collapse all

On This Page

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.

REFERENCES

SQL Server 2000 Books Online: topics; "SQL Mail"; "Configuring Mail Profiles"; "How to set up SQLAgentMail"

Properties

Article ID: 315666 - Last Review: January 17, 2015 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbpending KB315666

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com