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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chuck - 10 Feb 2008 20:49 GMT

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 to this Message

Michael M - 10 Feb 2008 22:19 GMT

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

> 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 to this Message