| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add email attachment to command button
I put a command button on my spreadsheet and would like the code to email the
spreadsheet when clicked. Probably should save it too before mailing. Thanks for you programming skills! :) |
|
#2
|
|||
|
|||
|
Hi Shinka
See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... I put a command button on my spreadsheet and would like the code to email the spreadsheet when clicked. Probably should save it too before mailing. Thanks for you programming skills! :) |
|
#3
|
|||
|
|||
|
Very helpful, Thanks. I can use them if I attach it as a macro to a
'button'. Get errors if trying to insert it in a 'command button' between: Private Sub CommandButton1_Click() End Sub What is the proper way to insert it? "Ron de Bruin" wrote: Hi Shinka See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... I put a command button on my spreadsheet and would like the code to email the spreadsheet when clicked. Probably should save it too before mailing. Thanks for you programming skills! :) |
|
#4
|
|||
|
|||
|
Hi Shinka
Enter only the macro name in the click event and copy the macro in a normal module -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... Very helpful, Thanks. I can use them if I attach it as a macro to a 'button'. Get errors if trying to insert it in a 'command button' between: Private Sub CommandButton1_Click() End Sub What is the proper way to insert it? "Ron de Bruin" wrote: Hi Shinka See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... I put a command button on my spreadsheet and would like the code to email the spreadsheet when clicked. Probably should save it too before mailing. Thanks for you programming skills! :) |
|
#5
|
|||
|
|||
|
That was too simple...LOL
I tried making it a Private Sub, renaming the box to Mail, etc.. Your site is now in my favorites. Thanks alot Ron "Ron de Bruin" wrote: Hi Shinka Enter only the macro name in the click event and copy the macro in a normal module -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... Very helpful, Thanks. I can use them if I attach it as a macro to a 'button'. Get errors if trying to insert it in a 'command button' between: Private Sub CommandButton1_Click() End Sub What is the proper way to insert it? "Ron de Bruin" wrote: Hi Shinka See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... I put a command button on my spreadsheet and would like the code to email the spreadsheet when clicked. Probably should save it too before mailing. Thanks for you programming skills! :) |
|
#6
|
|||
|
|||
|
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... That was too simple...LOL I tried making it a Private Sub, renaming the box to Mail, etc.. Your site is now in my favorites. Thanks alot Ron "Ron de Bruin" wrote: Hi Shinka Enter only the macro name in the click event and copy the macro in a normal module -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... Very helpful, Thanks. I can use them if I attach it as a macro to a 'button'. Get errors if trying to insert it in a 'command button' between: Private Sub CommandButton1_Click() End Sub What is the proper way to insert it? "Ron de Bruin" wrote: Hi Shinka See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Shinka" wrote in message ... I put a command button on my spreadsheet and would like the code to email the spreadsheet when clicked. Probably should save it too before mailing. Thanks for you programming skills! :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatted sheets get unformatted when send via email attachment? | Excel Worksheet Functions | |||
| Excel Spreadsheet email attachment unable to open in Outlook Expr. | Excel Discussion (Misc queries) | |||
| how do you open an email attachment that is an excel speadsheet w. | Excel Discussion (Misc queries) | |||
| Email a single sheet as attachment ?? | Excel Discussion (Misc queries) | |||
| email portion of spreadsheet as attachment | Excel Discussion (Misc queries) | |||
Linear Mode
