Email Macro - How to send to two email addresses?

[XL Learner]

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

 

[XL Learner]

Is it even possible to send to two different emails simultaneously?

 

[Smitty]

Is it even possible to send to two different emails simultaneously?

Sure, although the SendMail method is pretty limited. What's your e-mail client? If it's Outlook, see www.rondebruin.nl/sendmail.htm

Ron's got all the Outlook code you'll need and he does a great job of explaining it.

If you have a different e-mail client then post back and I'll try to point you in the right direction.

HTH,

 

[XL Learner]

Thanks alot. We use Outlook, I'll check out your link.

 

[XL Learner]

Just wanted to say thanks. The link contained enough information for me to figure out what I needed.

Thanks again.