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