hello, me again. Is it possible to retrieve data from a table which is then automatically e-mailed to a recipriant? (this would be done, simply by clicking on an image of some sort) thanks matt

-- Anonymous, August 17, 1999

Answers

Matt,

Yes, you will want to write sql code or a stored procedure that fetches the data from the table and used xp_startmail to start your e-mail server and xp_sendmail to send the email. You can read about these in the SQL Server Books Online. Note that there is an error in the documentation. You will need to specify the e-mail recipients with the "@recipients" argument rather than "@recipient".

Good luck,

Eric

-- Anonymous, August 17, 1999