Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 562
  • Last Modified:

sql db email, sql 2005, sql 2008

i have a query written with sql db email

EXEC msdb.dbo.sp_send_dbmail
       @recipients=@customeremail,
       @replyto_address = @storeemail,
     @subject = 'Thank You' ,
     @body = @tableHTML,
     @body_format = 'HTML'

i am getting an error

Msg 8145, Level 16, State 1, Procedure sp_send_dbmail, Line 0
@replyto_address is not a parameter for procedure sp_send_dbmail.


can some onehelp with this.
0
romeiovasu
Asked:
romeiovasu
  • 3
  • 2
1 Solution
 
MPKRCommented:
This parameter is not a valid one. You cant use it. Youmust configure the account to do this.
 
check out this page> http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx
 
0
 
romeiovasuAuthor Commented:
but here it shows how to configure live email and gmail.com
0
 
MPKRCommented:
It shows how to set up database email. This is what is neccesary to use it. And to configure it you have to specify an realexisting Email account to send. There you can define the reply to address. Only there, not when sending the mail out usingthis account.
The used email providers there are just samples. If you do not have access to the Database email configuration you should talk to your administrator person to do it.
0
 
romeiovasuAuthor Commented:
i didnt get it what i was looking for. i have already configured perfectly. all i wanted was to pass variable to reply to address i no it cannot be happend but i was looking some other alternatives.
0
 
MPKRCommented:
You can write your own Send_EMAIL Procedure and include a reply_to parameter. Inside of the procedure you must check (SELECT CASE) what value was passed and depending on this value select another SQL DataBase PROFILE from you configuration. Inside of the different configurations (Profiles) select different Accounts (including REPLY TO addresses).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now