|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
xp_sendmail errorHi,
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 Reason: You're trying to send mail to an email address that doesn't exist.
Resolution: Change the recipient to an address that exists. 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. > > > 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. -- Show quoteSevugan.C "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. > > > > > > > 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 quoteTibor 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. >> >> >> > 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. > >> > >> > >> > > > > 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. 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. >>>> >>>> >>>> >>>> >>>> >> >> |
|||||||||||||||||||||||