The Form Auto Module adds a new form type called Automatic Form, which allows you to store the form values into an auto-managed table (as you modify form name and form fields), adds filter, unique and count/total validation and also adds a confirmation e-mail using HTML template with inserttags.

This is quite an advanced module, so don't be surprised if you can't understand all the options in the beginning.

FormAuto Manual
http://www.thyon.com/formauto.html