Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get a send email button to send emails to multiple addresses.
I can get it to work for one address, but I don't know how to do multiples. Here's the code: wb1.SaveCopyAs TempFilePath & TempFileName & FileExtStr Set wb2 = Workbooks.Open(TempFilePath & TempFileName & FileExtStr) With wb2 On Error Resume Next .SendMail ", _ "Product" On Error GoTo 0 .Close SaveChanges:=False End With 'Delete the file Kill TempFilePath & TempFileName & FileExtStr With Application .ScreenUpdating = True .EnableEvents = True Can anyone help? Also, when I click on this button, a security warning pops up asking if I want to enable the macros, which I do. How do I turn that pop up off? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to send email to multiple addresses | Excel Worksheet Functions | |||
Excel Macro to email to addresses in "Contacts" Tab | Excel Programming | |||
copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
Email from Excel; MS warning "program is trying to send mail on your behalf" | Excel Programming | |||
VB code to "Send To" Multi addresses | Excel Programming |