retrieve data then send : LUSENET : SQL Server Database Administration : One Thread

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



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,


-- Anonymous, August 17, 1999

Moderation questions? read the FAQ