Email Excel spreadsheet to multiple recipients

[gooniegirl180]

Hi all,

I need a short piece of code which takes our open, current macro-enabled workbook and emails it to three different email receipients.

All the research I've done so far has only resulted in either code which allows the email to go to a single recipient, or code which is so long and involved and checks versions etc etc which doesn't apply to what we need the file to do (it doesn't matter once it's emailed if the VBA code doesn't work anymore). We want to hard-code the email addresses into the macro (yes, I know it's not good practice, but I'm teaching a rookie - HA! Blind leading the blind - and want to keep it simple).

We've put in this code:
ActiveWorkbook.SendMail "recipient1", "Subject"
ActiveWorkbook.SendMail "recipient2", "Subject"
ActiveWorkbook.SendMail "recipient3", "Subject"

but we keep getting asked by Outlook if we want to Allow, Deny or Get Help for each user. We just want the file to send and don't want to be asked this!

So, two questions: How do we send to multiple recipients, and how do we prevent the Outlook confirmation from coming up?

Thanks & Regards,
gooniegirl180