| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
| Sending E-mail | Excel Programming | |||
| Sending E-mail | Excel Worksheet Functions | |||
| Help sending mail... | Excel Programming | |||
Threaded Mode
