Macro to email sheet1

[buwa84]

Hello,

I have userform that clients fill. The form fields are mapped to sheet1. When a client clicks submit on the VBA userform i want the macro to email sheet1 to a email address thats located in sheet2.A3

Is this do-able.

[bryanmarks]

I think this is very doable, but without any code, it's hard to tell you how to do it. Plus, I'm pretty new at this myself.

I'd suggest going to Ron de Bruin's website to look for the code you need: http://www.rondebruin.nl/index.htm. There is very useful code there for how to email Excel files and single worksheets.

Bryan