I am trying to create a procedure that will take a value (email addy) from a Front Page (gross I know) form that will in turn use that email address to send via sql mail. Im trying to figure out the best way to do this... I'm used to Oracle Databases, where you can grab the :NEW (this being the value inserted) and then use it. Is there an equivalent in SQL Server to :NEW ? I tried to write a procedure that will use XP_MAIL, but when I said USE MASTER XP_SENDMAIL ... I get a syntax error saying that I can't use the USE command in a trigger or procedure! Can anyone helP?