Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
email Button
Hello All,
I'm trying to create a button that when pressed it sends an email to a specific email address. That is... Button 1 pressed send current worksheet to address Button 2 pressed send current worksheet to address & so on Thnx, BadRasta |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
email Button
You could use a macro with the following line:
ActiveWorkbook.SendMail " Excel will attempt to send it using the default mail client (if there is one) and give the message a subject that is the document name. You could create the button with the Forms toolbar and assign your macro to it. There's probably a way to force a custom subject line - anyone know? On May 9, 12:40 pm, BadRasta! wrote: Hello All, I'm trying to create a button that when pressed it sends an email to a specific email address. That is... Button 1 pressed send current worksheet to address Button 2 pressed send current worksheet to address & so on Thnx, BadRasta |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
email Button
Hi BadRasta
See this page http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BadRasta!" wrote in message ... Hello All, I'm trying to create a button that when pressed it sends an email to a specific email address. That is... Button 1 pressed send current worksheet to address Button 2 pressed send current worksheet to address & so on Thnx, BadRasta |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
email Button
Is there a way to record the Macro with a line just to send a single sheet
not the entire workbook? "Reitanos" wrote: You could use a macro with the following line: ActiveWorkbook.SendMail " Excel will attempt to send it using the default mail client (if there is one) and give the message a subject that is the document name. You could create the button with the Forms toolbar and assign your macro to it. There's probably a way to force a custom subject line - anyone know? On May 9, 12:40 pm, BadRasta! wrote: Hello All, I'm trying to create a button that when pressed it sends an email to a specific email address. That is... Button 1 pressed send current worksheet to address Button 2 pressed send current worksheet to address & so on Thnx, BadRasta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BCC Email using a Command Button | Excel Discussion (Misc queries) | |||
MS Excel Email button Help | Excel Discussion (Misc queries) | |||
MS Excel email button | Excel Discussion (Misc queries) | |||
Email button??? | Excel Worksheet Functions | |||
Button to email my spreadsheet | Excel Discussion (Misc queries) |