VBA .SendMail to Multiple Recipients

If one does not want to use CDO to send email, following is the way to send a single email to multiple recipients. However, it appears there is no way to send cc or bcc through .SendMail in VBA.

.SendMail Array("person1@sample.com", "p2@sample.com"), _
"This is the Subject line"

Or

.SendMail Array("person1@sample.com", "p2@sample.com"), _
Subject:="This is the Subject line"

This is particularly useful with work together with ActiveWorkbook in Ms Excel.

For more information, please see:

Ron de Bruin's http://www.rondebruin.nl/mail/tips1.htm