Create a new Data Connection and then select submit and to email.
You can set fields or static values for the to and subject etc.
In 2003 attachment is automatic, in 2007 you can choose to send the form as an attachment or not.
You can also just email a hyperlink to.