Email button

[Guest]

I wish to have a button on a user form to be able to email the form. Not
knowing much about VBA I am not sure if it is possible

Thanks

 

[Sean]

I wish to have a button on a user form to be able to email the form. Not
knowing much about VBA I am not sure if it is possible

Thanks

Check out this site, it has example codes etc http://www.rondebruin.nl/sendmail.htm

Then just create a button and assign the macro that you have created
to it

 

[Guest]

hi,
you may not be able to email the form but you can email the data in the form
if you can get it on the sheet.

See this web site.
http://www.rondebruin.nl/sendmail.htm

Regards
FSt1

 

[Guest]

How would this work for emailing the contents of several list boxes to those
with email adresses in all the sheets?

 

[Brice Cunningham]

In Excel 2010

1. Enable Developer Mode
*File | Options | Customize Ribbon | Select check box for Developer and click OK
2. Developer | Macros | Create a new macro and name it Email
*Macro code:
Application.Dialogs(xlDialogSendMail).Show arg1:="(e-mail address removed)", _
arg2:="This goes in the subject line"

3. Insert | Shape | Pick a shape for the button and drag over an area of your workbook
4. Right click shape and choose assign macro