?
Solved

Reply Email Address in Database Mail being Ignored

Posted on 2008-11-20
9
Medium Priority
?
309 Views
Last Modified: 2012-05-05
Hi I have a Database Mail account that is using an administrator email account to send out various information to users.  This email address should not however be the reply address which should be the development team.
I have set up the account as follows
E-Mail Address: Administrator@mycompany.co.uk
Display Name: Administrator Reports-Server
Reply e-mail: IT@mycompany.co.uk
Server name: Mymail   Port Number:  25
The email function works fine, but when a recipient hits reply, Outlook is addressing the new email to Administrator@mycompany.co.uk rather than IT@mycompany.co.uk

Is this the expected behaviour?  How can I get replies to come to the right mailbox?

Thanks
0
Comment
Question by:GeniusSteals
  • 6
  • 3
9 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 23073952
Multi steps.... easy to skip one...



-- Create a Database Mail account
EXECUTE msdb.dbo.sysmail_add_account_sp
    @account_name = 'AdventureWorks Administrator',
    @description = 'Mail account for administrative e-mail.',
    @email_address = 'dba@Adventure-Works.com',
    @replyto_address = 'danw@Adventure-Works.com',
    @display_name = 'AdventureWorks Automated Mailer',
    @mailserver_name = 'smtp.Adventure-Works.com' ;
 
-- Create a Database Mail profile
EXECUTE msdb.dbo.sysmail_add_profile_sp
    @profile_name = 'AdventureWorks Administrator Profile',
    @description = 'Profile used for administrative mail.' ;
 
-- Add the account to the profile
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
    @profile_name = 'AdventureWorks Administrator Profile',
    @account_name = 'AdventureWorks Administrator',
    @sequence_number =1 ;
 
-- Grant access to the profile to the DBMailUsers role
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
    @profile_name = 'AdventureWorks Administrator Profile',
    @principal_name = 'ApplicationUser',
    @is_default = 1 ;

Open in new window

0
 
LVL 1

Author Comment

by:GeniusSteals
ID: 23076452
Though I set up the account/profile using the Wizard rather than by script, I think all those points are taken into account.

I have attached a view of the Wizard when trying to configure the account.

Everything looks to be set up correctly. I'm wondering whether the problem may lie outside of Database Mail and with Outlook.


MailboxSetup.JPG
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 23077109
Yes, could be - The setup does look OK, so might be something interesting with that address... I mean there is the obvious question that it@mycompany.co.uk is set up in your exchange server...   and all the interesting bit are crossed out ;)

But, on further experimentation, configuration, and testing, the reply_to does not work.

Have checked with a couple of colleagues and they concur - only one way, put the reply to address in the "E-MAIL"  it does not even check if it is real - I had santa.clause@northpole.cold and put in a display name of Hppy Holidays and sure enough it came through. My inbox just showed the display name, and the e-mail had display Name and the bogus address, did a reply and it bounced.

So, the reply to is no go, use the e-mail address as the reply to
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 51

Expert Comment

by:Mark Wills
ID: 23077243
apologies was not northpole.cold - that one failed, but my own site has a catchall account and second one did come through as santa.clause@myaccount.com

the rest is quite true and accurate...
0
 
LVL 1

Author Comment

by:GeniusSteals
ID: 23495902
Closing question as not resolved
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 23496147
Ummm, you might not have liked my answer but it is the real answer. The reply to is no go, use the e-mail address as the reply to.
0
 
LVL 1

Author Comment

by:GeniusSteals
ID: 23496230
Thanks but that is not the real answer.  That is just saying that the reply-to doesn't work.  I already noticed that which is why I posted the question...

Either there is a way for the Reply-to to function correctly or something needs to be done in Exchange to facilitate it.  

I need the Reply-to email address to be different from the Email address and it looks like SQL Server provides a way of doing this.

Apparently not...
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 2000 total points
ID: 23496299
Yes, in exchange, you can set up a reply e-mail address for your administrator@your_company.com account.

as a simple test go into config, e-mail accounts, select that e-mail account there are advanced options and nominate the reply-to
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 23496419
or if testing and have outlook with admin access go into outlook tools, e-mail accounts, select the account, change, more settings, first tab has a reply to down the bottom.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
By default Outlook 2016 displays only one time zone in the Calendar. The following article explains how to display two time zones in one calendar view.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question