Hey everyone would really appreciated a little advice from a word macro/form guru....

I have created a form (not a webform, just a normal one) that has check boxes, drop down lists and a few text boxes.... I have named all the "bookmarks" so i can understand the export data, but would effectively like to automate the save and export procedure....

My goal is to have a submit button that will automatically save the form with a naming convention pulled from the form (in my case i would like it to pull the textvalues from the bookmarks "Name" and "Date" to end up with a saved naming convention of Name_Date.doc) then i would also like to be able to automate the exporting of the form values to a CSV txt document, so later on i can import all the form's results into an excel document.

Does anyone know an easy way to create a button that runs the commands to create the naming convention from values from 2 textboxes, then save it as both a .doc and as a comma seperated values txt file.

Your help would be greatly appreciated as i need to get this form done asap!!!