March 19, 2008 at 8:00 am
I have setup database mail and can send email using it. I added a reply to account to the DBMail account and assumed when I reply to the SQL generated email I would see the reply go to the Reply To account. But, alas, it only is returned to the sending email account. When I look at sp_send_dbmail, I do not see a Reply To parameter. Having found this I am forced to assume that MS never actually implemented the Reply To functionality. Has anyone else tried this? If you have, had you had success?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 19, 2008 at 6:29 pm
Can only confirm what you're seeing.
Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.
From looking at a packet capture of the SMTP traffic, 'Reply-To:' was nowhere to be found in the message body.
This issue at connect.microsoft.com appears similar and is still open for feedback:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=264498
March 19, 2008 at 10:00 pm
Thanks for the confirmation Todd. I did a quick google and did not find anything so I made this quick post hoping someone would have a little more information. I have only been working with 2005 for a few months so I thought someone would have seen this.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 20, 2008 at 10:41 pm
You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list of valid email addresses of the sending account - dependent on relay-settings as well.
Joe
March 21, 2008 at 8:11 am
Interesting. I have a reply-to address setup for my Database Mail profiles and it seems to work just fine. I'd be interested in hear what you find in regard to this problem.
😎
March 21, 2008 at 8:28 am
Joe Clifford (3/20/2008)
You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list of valid email addresses of the sending account - dependent on relay-settings as well.Joe
Yes we are using Exchange. I'll try it using gmail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 21, 2008 at 8:59 am
A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.
Lynn,
What mail server are using for SMTP? I am on SQL 2005 64-bit SP2. Any differences with your setup? I have tried our local exchange server and gmail now.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 21, 2008 at 9:17 am
My reply to works just fine ... curious to hear what you find out ... Anything you'd like me to find out from our exchange guy?
March 21, 2008 at 9:22 am
Todd Engen (3/19/2008)
Can only confirm what you're seeing.Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.
From looking at a packet capture of the SMTP traffic, 'Reply-To:' was nowhere to be found in the message body.
This issue at connect.microsoft.com appears similar and is still open for feedback:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=264498
Adam,
Did you check out the link Todd posted? I did and it seems that it is a bug. Are you using 32 or 64-bit SQL? I am using 64-bit. I will try it on the 32-bit version I am running on my desktop to see if that may be the issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 21, 2008 at 9:28 am
Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...
Anyways, both in x86 and x64, I changed the replyto email, and when I reply, it is in fact using the sender in the reply to.
Just tried it in the latest CTP of 2008, and the same problem resides. So now more than ever I'm curious to as what is causing this.
March 21, 2008 at 9:36 am
Adam Bean (3/21/2008)
Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...Anyways, both in x86 and x64, I changed the replyto email, and when I reply, it is in fact using the sender in the reply to.
Just tried it in the latest CTP of 2008, and the same problem resides. So now more than ever I'm curious to as what is causing this.
Great! I just assumed it was a something not-quite finished in 2005 and they forgot to remove the reply to filed from the wizard and the account sp and it would be there in 2008. I posted on my blog about this and called it the The Ghost of Reply To in Sql Server 2005 Database Mail.
Thanks for testing it out. Pretty interesting.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 21, 2008 at 1:00 pm
Jack Corbett (3/21/2008)
A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.Lynn,
What mail server are using for SMTP? I am on SQL 2005 64-bit SP2. Any differences with your setup? I have tried our local exchange server and gmail now.
We are using Exchange as our SMTP server.
😎
March 21, 2008 at 1:15 pm
Okay, I used sp_send_dbmail to send an email to one of my coworkers, who replied to it, and it went just where I expected it to go, me. So I know the the reply to part of my database mail setup is working correctly.
Perhaps we should compare how things are setup.
😎
March 21, 2008 at 1:21 pm
I will be leaving work shortly. I have a school event for my youngest followed with my hitting the High School pitch (got a JV game to officiate!).
Next week I will be in an on-site SQL Server 2005 training class, but i'll check back when I can. Also, tonight I can copy down my setup and post it if that will help.
😎
March 21, 2008 at 2:43 pm
Have fun officiating. I used to that quite often as well. I thought DBA's were supposed to be geeks!
If you could post the setup I'd appreciate it. I will be looking into more on Monday as well. I actually had today off for Good Friday.;)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 1 through 15 (of 35 total)
You must be logged in to reply to this topic. Login to reply