XL Learner
New Member
- Joined
- Oct 8, 2007
- Messages
- 20
I have a macro that I copied from another workbook ( I don't know VBA) that allows me to email a workbook to a designated email address. I just keep copying and pasteing the macro, customizing it for every spreadsheet that I use it in.
What I would like to know, is there a way to change it so that the spreadsheet goes to more than one email address?
Here is my macro:
Sub TextBox1_Click()
MsgBox "For this [Insert File Name Here] to be processed you must select YES on the next Text Message Box that appears."
ActiveWorkbook.SendMail "[Insert Email Address Here]", "[Insert Subject of Email Here]"
ThisWorkbook.Close False
End Sub
What I would like to know, is there a way to change it so that the spreadsheet goes to more than one email address?
Here is my macro:
Sub TextBox1_Click()
MsgBox "For this [Insert File Name Here] to be processed you must select YES on the next Text Message Box that appears."
ActiveWorkbook.SendMail "[Insert Email Address Here]", "[Insert Subject of Email Here]"
ThisWorkbook.Close False
End Sub