I am not sure what is the exact error message that you are getting, but if you
are getting below error message:
Error 18030: xp_test_mapi_profile : Either there is no default mail client or
the current mail client cannot fulfill the messaging request. Please run
Microsoft Outlook and set it as the default mail client.
then please try/check the following steps:
1.) Delete your old profile and create a new one
2.) After you create the new profile, stop and restart SQL Server
3.) Make sure that you are able to send and receive e-mail messages using
4.) Make sure that you are logged in with the proper Domain account
Please take a look at Q263556 INF: How to Configure SQL Mail and make sure that
you have checked all the steps mentioned in this article.
Here are couple of more articles that might interest you:
Q315886 INF: Common SQL Mail Problems
Q311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
Q281293 SQL Mail 2000 Needs Microsoft Outlook 2000
I hope the information addresses your question.
MS - SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.