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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-26 : 11:32:27
|
| Vijay writes "Hi,I have written a SPROC to get name, email etc. from a table and then declare a varchar variable to construct a email message(with all string formats) and store that in a table. Later I am using that table to send an email with that formatted message. When the email is sent out, the formatted message doesn't look like what I am expecting (character position). Can any one help me how to format text to semd emails?Thanks,-Vijay" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-26 : 19:58:25
|
| I think this depends a LOT on what technique you are using to send the email. If you are using xp_sendmail, I don't know that it's possible to do any formatting. If you are using CDO, you can format your body string as HTML and probably get the result you're looking for. There are, of course, many, many other email sending options, so check your documentation for more details. |
 |
|
|
|
|
|
How to Format a string to use in emails