Error in sending mail xp_send mail

[Bhanusriram]

Error in sending mail xp_send mail

 

[tlbroadbent]

What was the error? What is the statement that generated the error? Which version of SQL Server? What is the Email provider? We can't help if you don't provide some more information. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Bhanusriram]

Hi,
Thanks for ur response.
We are using SQL 2000,Microsoft Outlook 2000.
When I execute xp_sendmail stored procedure, error occur as
"xp_sendmail: failed with mail error 0x80040111"

But when I configured MAPI Profile for the SQL server, it is accepting it.
After executing the above stored procedure,i am getting the error.
Regards,
Bhanu

 

[tlbroadbent]

Are there any messages in the SQL error log that give additional info regarding the error? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jhall156]

Are you using xp_readmail to get the MsgID GUID? Are you using sp_ProcessMail? Can you provide us with the code you're using?

 

[Bhanusriram]

Hi,
Now I rectified the error which occured while running stored procedure.The problem now is after the stored procedure is run,the output is displayed as "mail sent successfully".But the mail is not sent to the respective user instead it is returned back because of the following reason.

Your message did not reach some or all of the intended recipients.

Subject: SQL Server Message
Sent: 12/3/01 3:20 PM

The following recipient(s) could not be reached:

'=SMTP:bhanuv@ctd.hcltech.com' on 12/3/01 3:20 PM
No transport provider was available for delivery to this recipient.

It is taking '=SMTP: in addition with user name'.
Could u please tell me how to bypass that?
It would be great if u could provide me a suitable solution as soon as possible.
Regards,
Bhanu