ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   email user form (https://www.excelbanter.com/excel-programming/402151-email-user-form.html)

TotallyConfused

email user form
 
On reviewing forum for help with emailing user form, I found this link
http://www.rondebruin.nl/mail/folder1/mail1.htm with instructions. I am new
to User Forms and would like some help as to where and how I can incorporate
this into my user form. The code lists "worksheets" not user forms. Can
this be applied to my user form. I would like to have a button on my main
screen that when I click on the command button it will email form. Thank you
for any help on this .

John Bundy

email user form
 
Just double click the button the same way you would to put code in in and
copy/paste the code in minus the sub/end sub. Don't forget to change the
email address, wonder how many emails he gets?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"TotallyConfused" wrote:

On reviewing forum for help with emailing user form, I found this link
http://www.rondebruin.nl/mail/folder1/mail1.htm with instructions. I am new
to User Forms and would like some help as to where and how I can incorporate
this into my user form. The code lists "worksheets" not user forms. Can
this be applied to my user form. I would like to have a button on my main
screen that when I click on the command button it will email form. Thank you
for any help on this .



All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com