Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default 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 .
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 772
Default 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 .

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Call user form from ThisWorkbook; close file if form closed XP Excel Programming 2 July 20th 07 07:04 PM
Automatically add a textbox to a user form based on user requireme Brite Excel Programming 4 April 7th 07 11:37 PM
User form ComboBox Items: Remember user entries? [email protected] Excel Programming 0 March 29th 07 06:41 PM
Auto email - With every new entry on my user form Vikram Excel Discussion (Misc queries) 0 June 19th 06 06:00 AM
How to: User Form to assign a user defined range to a macro variab TrevTrav Excel Programming 1 March 22nd 05 07:57 PM


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"