Thread: Sending mail
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Franz E Franz E is offline
external usenet poster
 
Posts: 3
Default Sending mail

Online help says:
- for one recipient you need to use text, exactly as you do
- for more than one recipient you need to use a matrix with text strings.


"Tomas Stroem" wrote:

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