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-03-18 : 10:03:34
|
| Kevin writes "I am using SQL 2000 and I have used the wizard to create a scheduled job that queries the database and creates a web page with the results. I want to be able to e-mail that web page to persons who do not have access to the web server.I do not want to install Outlook or exchange client on the server. I have read your explanations of SendMail and SMTP procedures but I want the body of the message to be the results of a query and/or the web page itself.Is this even possible?Thanks from a Frustrated SQL 2000 NewbeeeeeeeeeeKevin" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-18 : 18:02:38
|
| How is your VBScript ?You could use it (just as you would with ASP) to read the HTML from that page and set that as the body of the mail.Damian |
 |
|
|
|
|
|
E-Mail Database Results HTML page