BUG: XP_SENDMAIL Fails to Send Mail to Personal Distribution List

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:

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.

REFERENCES

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