Hi I created a Stored Procedure that sends e-mails. Here is part of it:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Orders_at_TDGarden_profile',
@recipients = '@email_address'
@body = @strBody ,
@subject = @strSubject
It's supposed to send an e-mail to a speficic email address when they place and order for tickets. This @email_address is supposed to pull the corresponding address. When I set the @recipients to my own e-mail address, everything works perfectly. But when I add in '@email_address' along with my e-mail, I don't recieve an e-mail. I declared @email_address and everything. Any ideas?
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Orders_at_TDGarden_profile',
@recipients = '@email_address'
@body = @strBody ,
@subject = @strSubject
It's supposed to send an e-mail to a speficic email address when they place and order for tickets. This @email_address is supposed to pull the corresponding address. When I set the @recipients to my own e-mail address, everything works perfectly. But when I add in '@email_address' along with my e-mail, I don't recieve an e-mail. I declared @email_address and everything. Any ideas?