View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TinaF TinaF is offline
external usenet poster
 
Posts: 3
Default 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