Version of the database and email requirements would be nice. It sounds like 9i or lower, in which case you will probably be looking at UTL_SMTP unless you require attachments, but version does make a difference. In the mean time I'm pretty sure that there is a good discussion of the issues on asktom. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- //www.freelists.org/webpage/oracle-l