Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TIA
Starting Member
1 Post |
 Posted - 2005-06-24 : 17:32:41
|
Can any one explain how to use something like ASP Mail or Jmail in conjunction with SQL? I need to send Name, email address and other data to populate variables in a pre-formatted RTF or HTML email message. Like mail-merge only mail templates based on criteria that triggers a stored Procedure. I read the article:http://www.sqlteam.com/item.asp?ItemID=5003I get that an email can be sent via a sp but don't see how to format the email beyond simple text via @BodyAny ideas? |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-26 : 15:44:31
|
| Have you tried feeding @body an HTML string? Have you thought about how you are going to handle users who have HTML email disabled?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
|
|
|
Nicely Formated SQL triggerd Email