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

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