Button with Macro to Email sheet to multiple addressees

[TinaF]

I have the following code to email a spreadsheet to one recipient:

Sub EmailTimesheet()
ThisWorkbook.SendMail "[email protected]", "Timesheet"
End Sub

How do I change this to send it to multiple recipients?

Thanks.
Tina

 

[Gord Dibben]

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