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-04-01 : 09:17:44
|
| bheemsen writes "Is it possible to send the contents of a text file as pasted into the email body as message. I don't want to attach the file. If I have 20 lines in a text file, they should be pasted in the mail body as message (like this) and sent.I am on SQL server 7.0 and using VB script in DTS package to send the email using xp_sendmail. If I create a variable and pass it to @message, it is becoming one long string and not multiple lines. I want the complete text of the file to be pasted into the email body and sent. Please help. Thanx..-Bheemsen" |
|
|
|
|
|
Body of email using xp_sendmail