Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I set a button in a sprdsheet to email that sprdsheet to me
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I set a button in a sprdsheet to email that sprdsheet to me
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 "chuck" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to be able to count the no. of times a sprdsheet is opened | Excel Discussion (Misc queries) | |||
Email button??? | Excel Worksheet Functions | |||
Button to email my spreadsheet | Excel Discussion (Misc queries) | |||
Email button within Excel | Excel Worksheet Functions | |||
I have user defined functions in sprdsheet. I want to put sprdsh. | Excel Worksheet Functions |