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 |
|
nancy_lee
Starting Member
18 Posts |
 Posted - 2002-12-12 : 15:57:20
|
| I am trying to use sql to send emails to Lotes Notes. Here's what I code for the body :select @body = '<html>'+@body+'</html>'If I do not use html tags then content of @body is not showing up... it will just send a blank emailWhen I put the tags around it ,then the value and the tags both shown.How can I hide the tags... I have a feeling this is not the way to code.Please help!Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-12 : 16:02:42
|
| It probably depends more on what method you're using to move the email to Lotus Notes, and whether that method supports HTML email or not. Some COM packages have a MailFormat property that must be set regardless of whether the HTML tags appear in the body or not. xp_sendmail does NOT support HTML formatting, for instance, although there may be a workaround that allows it. If the mail format is set to text, then adding <HTML> tags will only convert them to text, and not be interpreted correctly. |
 |
|
|
nancy_lee
Starting Member
18 Posts |
Posted - 2002-12-12 : 16:05:38
|
| disregard the previous questions... it seems to be alright now...however I have another question ...Since there is a limitation with 8000 characters I will need to create a template for the email to send out for my users... here's the question:How do I put the data from sql onto the template ?e.g.the email looks like this:To : MR. Johnston( this field is generated from sp)From : .....The template is To: and From : How do I incorporate the two.Please help!Thanks! |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-12 : 17:09:59
|
| You can create a variable with the template text and use something like #To# to hold space for the value then use the Replace function to Replace #To# with your variable. |
|
|
|
|
|
|
sql with html tags for email