| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button with Macro to Email sheet to multiple addressees
I have the following code to email a spreadsheet to one recipient:
Sub EmailTimesheet() ThisWorkbook.SendMail ", "Timesheet" End Sub How do I change this to send it to multiple recipients? Thanks. Tina |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Button with Macro to Email sheet to multiple addressees
Just about all you need for email functions from Excel can be found at Ron
de Bruin's site. http://www.rondebruin.nl/sendmail.htm Gord Dibben MS Excel MVP On Tue, 29 Jul 2008 07:21:05 -0700 (PDT), TinaF wrote: I have the following code to email a spreadsheet to one recipient: Sub EmailTimesheet() ThisWorkbook.SendMail ", "Timesheet" End Sub How do I change this to send it to multiple recipients? Thanks. Tina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button - Macro to print to pdf, then send pdf to email. | Excel Discussion (Misc queries) | |||
| Ability to close a worksheet and email using a macro button | Excel Discussion (Misc queries) | |||
| Can I send a doc to group of email addresses via a macro button? | Excel Discussion (Misc queries) | |||
| use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
| Macro to email multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
