About Us

LESLIE

Thank you. I'll try it!

"JW" wrote:

Having a formula to open your default mail client with your name in it
is simple:
","E-mail completed form")

But, I believe what you are needing is going to require VBA.
You can add a button using the Forms Toolbar and assign the button to
a macro. The macro would look something like this:
Sub sendMacro()
ActiveWorkbook.SendMail ", _
"Completed Form"
End Sub
Leslie wrote:
I have created a form using Excel. I would like the people who fill out his
form to click a "Submit This Form" button at the top of his form and have
this button e-mail the form file to me (with the form file as an attachnemt
to the e-mail).

I need to know how to create a button in an Excel file, so that when you
click this button, it generates an e-mail addressed to a pre-specified
recipient (e-mail would be pre-addressed to me) with the completed form file
as an attachment to the e-mail.

I have a lot of experience working with Excel, so if possible, I'd prefer to
do this using a hyperlink and the capabilities of Excel, without using Visual
Basic. Is there a way to do what I need to do using Excel?
If Visual Basic is the only way this can be done, can you walk me through
the process of creating a button (and help me write the macro language) to do
this? (I have very little experience with Visual Basic!)

Thank you so much for your help!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a "Send" button	Leslie	Excel Discussion (Misc queries)	1	October 8th 07 11:51 PM
Signature missing when "send to" "mail recipient"	Jim Tortorelli	Excel Discussion (Misc queries)	2	September 21st 07 05:19 PM
Create a "cell button" to hide selected cells.	Shoolin Patel	Excel Worksheet Functions	12	July 30th 07 11:00 AM
Create Print "Button" in a cell	Fabledmyth	Excel Worksheet Functions	2	December 16th 06 05:50 PM
create links to check boxes marked "good" fair"and "bad"	pjb	Excel Worksheet Functions	3	April 20th 06 02:17 AM

Menu

About Us