how do I set a button in a sprdsheet to email that sprdsheet to me

C

chuck

I am writing a website. I have a link that opens an Excell spreadsheet. I
need the user to be able to enter some data and click a button field with a
hyperlink that will email the entire worksheet to me
 
M

Michael M

Hi Chuck

I use this code for sending an E-Mailed sheet to me.

Sub Email()
ActiveWorkbook.SendMail "E-mail Name"
MsgBox "This completed form has been sent to name"
End Sub

You can then put a button on the screen and assign this macro to it.

Regards
Michael M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have user defined functions in sprdsheet. I want to put sprdsh. 4
Can you hyperlink to a hyperlink? 1
Access Automatically Send a notification email once a record is added 0
How do you set a cell to increase numerical sequence? 2
How do i add a function button to a worksheet? 3
How to use multiple command button to copy user form data to multiple worksheet 0
Create a yes no message on a command button on click 0
RESET BUTTON 2

Top