Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Database Mail Reply To account Expand / Collapse
Author
Message
Posted Wednesday, March 19, 2008 8:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 11,305, Visits: 13,094
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #471578
Posted Wednesday, March 19, 2008 6:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
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
Post #472022
Posted Wednesday, March 19, 2008 10:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 11,305, Visits: 13,094
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472050
Posted Thursday, March 20, 2008 10:41 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 3, 2013 9:53 PM
Points: 433, Visits: 619
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



Post #472671
Posted Friday, March 21, 2008 8:11 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:47 PM
Points: 23,396, Visits: 32,229
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.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #472822
Posted Friday, March 21, 2008 8:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 11,305, Visits: 13,094
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472842
Posted Friday, March 21, 2008 8:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 11,305, Visits: 13,094
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472870
Posted Friday, March 21, 2008 9:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
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?

---
SQLSlayer
Making SQL do what we want it to do.

Post #472886
Posted Friday, March 21, 2008 9:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 11,305, Visits: 13,094
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472891
Posted Friday, March 21, 2008 9:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
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.


---
SQLSlayer
Making SQL do what we want it to do.

Post #472901
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse