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-02-04 : 09:52:03
|
| Gary writes "I have been using SQLmail with SQL 7.0 for a year now and the e-mail notifications that were created within triggers have no problem returning text fields. I am in the process of moving everything to an SQL 2000 database. The problem is that the text fields are returned like this:a lot of blank lines here on down to the dashes-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<text>Is there a way to remove these dashes and the unwanted blank lines so that the receipients do not have to scroll down the e-mail body to read the text? I have already tried using a temporary table, but the reults lack a column heading. Any help would be greatly appreciated.Gary Farrar" |
|
|
|
|
|
Formatting text fields in SQLmail