Home All Groups Group Topic Archive Search About
Author
7 Apr 2006 6:51 AM
Sevugan
Hi,

I am getting an error - 'Could not resolve recipient' while using
xp_sendmail stored procedure. What is the reason for this. How can I resolve
this.

--
Sevugan.C

Author
7 Apr 2006 7:00 AM
Mike Hodgson
Reason: You're trying to send mail to an email address that doesn't exist.
Resolution: Change the recipient to an address that exists.

--
*mike hodgson*
http://sqlnerd.blogspot.com



Sevugan wrote:

Show quote
>Hi,
>
>I am getting an error - 'Could not resolve recipient' while using
>xp_sendmail stored procedure. What is the reason for this. How can I resolve
>this.
>

>
Author
7 Apr 2006 7:42 AM
Sevugan
Hi Hodgson,

Thanks for your reply. No it is not like as you said. The e-mail address to
which I send the mail is a valid one.
--
Sevugan.C


Show quote
"Mike Hodgson" wrote:

> Reason: You're trying to send mail to an email address that doesn't exist.
> Resolution: Change the recipient to an address that exists.
>
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
>
>
> Sevugan wrote:
>
> >Hi,
> >
> >I am getting an error - 'Could not resolve recipient' while using
> >xp_sendmail stored procedure. What is the reason for this. How can I resolve
> >this.
> >
> > 
> >
>
Author
7 Apr 2006 7:46 AM
Tibor Karaszi
I've also seen this in cases where parts of the email addresses weren't unique. In my classes, I
initially tried with a naming scheme for accounts such as:

TKSERV1
TKSERV2
....
TKSERV11
TKSERV12
....

I don't recall if it was sending to TKSERV1 or TKSERV11 or both that failed. When I changed naming
scheme to TKSERV01..., it worked fine. I guess that one could check Outlook KB for what the exact
issue would be, in what way the part of the names cannot be duplicates, my guess is that it involves
when you have numbers at the end.

Show quote
"Mike Hodgson" <e1mins***@gmail.com> wrote in message news:esgWCEhWGHA.4768@TK2MSFTNGP05.phx.gbl...
> Reason: You're trying to send mail to an email address that doesn't exist.
> Resolution: Change the recipient to an address that exists.
>
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
>
>
> Sevugan wrote:
>
>>Hi,
>>
>>I am getting an error - 'Could not resolve recipient' while using
>>xp_sendmail stored procedure. What is the reason for this. How can I resolve
>>this.
>>
>>
>>
>
Author
7 Apr 2006 11:11 AM
B@DJJ
I've seen it respond with that message when you have the same "Display Name"
listed in Outlook for two (or more) different recipients - we always use the
full email address now to avoid that issue:

ie:
If you have two users listed so in Outlook:

Im A User (email address ImAU***@Wherever.com)

and

Im A User (email address ImAUs***@Somewhereelse.com)

will fail if you try to use xp_sendmail to send to Im A User - can't resolve
which one you mean.

HTH


Show quote
"Tibor Karaszi" wrote:

> I've also seen this in cases where parts of the email addresses weren't unique. In my classes, I
> initially tried with a naming scheme for accounts such as:
>
> TKSERV1
> TKSERV2
> ....
> TKSERV11
> TKSERV12
> ....
>
> I don't recall if it was sending to TKSERV1 or TKSERV11 or both that failed. When I changed naming
> scheme to TKSERV01..., it worked fine. I guess that one could check Outlook KB for what the exact
> issue would be, in what way the part of the names cannot be duplicates, my guess is that it involves
> when you have numbers at the end.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Mike Hodgson" <e1mins***@gmail.com> wrote in message news:esgWCEhWGHA.4768@TK2MSFTNGP05.phx.gbl...
> > Reason: You're trying to send mail to an email address that doesn't exist.
> > Resolution: Change the recipient to an address that exists.
> >
> > --
> > *mike hodgson*
> > http://sqlnerd.blogspot.com
> >
> >
> >
> > Sevugan wrote:
> >
> >>Hi,
> >>
> >>I am getting an error - 'Could not resolve recipient' while using
> >>xp_sendmail stored procedure. What is the reason for this. How can I resolve
> >>this.
> >>
> >>
> >>
> >
>
>
Author
10 Apr 2006 11:31 PM
Mike Hodgson
I didn't even consider that people might send to a MAPI "Display Name". 
I always send to a full SMTP address and only get that error when the
email address is invalid.

--
*mike hodgson*
http://sqlnerd.blogspot.com



B@DJJ wrote:

Show quote
>I've seen it respond with that message when you have the same "Display Name"
>listed in Outlook for two (or more) different recipients - we always use the
>full email address now to avoid that issue:
>
>ie:
>If you have two users listed so in Outlook:
>
>Im A User (email address ImAU***@Wherever.com)
>
>and
>
>Im A User (email address ImAUs***@Somewhereelse.com)
>
>will fail if you try to use xp_sendmail to send to Im A User - can't resolve
>which one you mean.
>
>HTH
>
>
>"Tibor Karaszi" wrote:
>

>
>>I've also seen this in cases where parts of the email addresses weren't unique. In my classes, I
>>initially tried with a naming scheme for accounts such as:
>>
>>TKSERV1
>>TKSERV2
>>....
>>TKSERV11
>>TKSERV12
>>....
>>
>>I don't recall if it was sending to TKSERV1 or TKSERV11 or both that failed. When I changed naming
>>scheme to TKSERV01..., it worked fine. I guess that one could check Outlook KB for what the exact
>>issue would be, in what way the part of the names cannot be duplicates, my guess is that it involves
>>when you have numbers at the end.
>>
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>>
>>"Mike Hodgson" <e1mins***@gmail.com> wrote in message news:esgWCEhWGHA.4768@TK2MSFTNGP05.phx.gbl...
>>   
>>
>>>Reason: You're trying to send mail to an email address that doesn't exist.
>>>Resolution: Change the recipient to an address that exists.
>>>
>>>--
>>>*mike hodgson*
>>>http://sqlnerd.blogspot.com
>>>
>>>
>>>
>>>Sevugan wrote:
>>>
>>>     
>>>
>>>>Hi,
>>>>
>>>>I am getting an error - 'Could not resolve recipient' while using
>>>>xp_sendmail stored procedure. What is the reason for this. How can I resolve
>>>>this.
>>>>
>>>>
>>>>
>>>>       
>>>>
>>   
>>

AddThis Social Bookmark Button