Thread: Sending mail
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tomas Stroem Tomas Stroem is offline
external usenet poster
 
Posts: 26
Default Sending mail

I want to send a file to multiple persons by using a macro that runs each
time the file is saved. It works perfectly well with one person, but not when
I try to add more names. What is the correct syntax to do this? Code added
below

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveWorkbook.SendMail ,
", Subject:="Filename"

End Sub

--
Tomas S