I have an infopath 2007 form where when filled out by an indiviidual, the data is sent to a sql server 2008 database. This form has a field for the person to enter an e-mail address of which an e-mail needs to be sent to a different person letting them know that the the data has been entered in the database. i'm not sure how to set up sql to take this e-mail address when a new record is created and send an e-mail to the intended recipient. perhaps someone could be of assistance.
i am using exhange 2007 as my e-mail server.