Thanks for replying Holger
Originally Posted by HaHoBe
I can get it to send it as a .xlsm by mangling the code a bit (see below) but I still can't figure out how to attach the macro modules with the new .xlsm that is emailed. I have attached my workbook as well if you want to check it out. You will have to add your email into the code for it to send itself. When you click submit it will use outlook to email it right back to you. You can then open the new workbook that is now an .xlsm but it is still missing the needed original workbooks macro modules.