Send email button in cell on spreadsheet?

[rcc1978]

I am new to excel. I ham stumped by a task i need to make happen. I want to have a cell in my sheet that enables the user to click on it to automatically send the sheet as an attachment to my email. I want it to have my email address already there to where all they have to do is hit send when the email pops up. thank you in advance.

[arndtb]

you could create a macro and assign it to a button. Your macro would look something like this

Please Login or Register  to view this content.

[rcc1978]

so i can just copy and paste this and just insert my email address and subject? And then just name the cell a certain thing like send email? sorry for all the questions.

you could create a macro and assign it to a button. Your macro would look something like this

Please Login or Register  to view this content.

[arndtb]

I believe so. I am new to writing VBA so that is the only reason i hesitate. Once you create the macro in your worksheet you can test it to be sure.

[rcc1978]

I am still learning how to set up MACROs.

[arndtb]

what version of excel are you using?

[rcc1978]

excel 2007

[arndtb]

1.If the Developer tab is not available, do the following to display it:
1.Click the Microsoft Office Button , and then click Excel Options.
2.In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

2.To set the security level temporarily to enable all macros, do the following:
1.On the Developer tab, in the Code group, click Macro Security.
2.Under Macro Settings, click Enable all macros, and then click OK.

4.On the Developer tab, in the Code group, click Macros.
5.Create a name for your Macro in the Macro name box.
6.Click Create.
7.In the code window of the Visual Basic Editor, paste the macro i posted for you.
Tip: To copy the whole macro, include the Sub and End Sub lines in the selection.

8.Close the Macro Window and the macro is in your spreadsheet. You will just need to create a button and assign the macro.

[rcc1978]

how do you create the button?

[arndtb]

on the developer tab you click the Insert button and you will see a list of things.
Hover over the first one you see and it should say Button (Form Control)
then go to your worksheet to "draw" the button as big as you would like. After drawing the button your assign macro box should open and ask you to assign the macro.
Once you have done all this you can name your button (if you haven't already done so) and/or move/resize your button if needed

[rcc1978]

I think I got it. Thank you for all your help.

[arndtb]

you're welcome