VBA that needs minor tweak to send to multiple email addresses

I have a code that sends out multiple emails all with different ranges as attachments from one spreadsheet. It works perfectly, however, I can only get it to send to one email address at a time. I would like to be able to send each range to up to 3 email address at the same time. I am still a beginner with VBA, so any help would be appreciated. I would like each email to be in the TO: section, but it would not kill me to put one in TO:, one in CC:, and one in BCC:. Thanks.

Please Login or Register  to view this content.

Hi,
As it is, the code reads the e-mail address form column N:

Please Login or Register  to view this content.

you can add all 3 e-mails in a single cell, separated by commas

or tell us from where it will read the other 2 in order to amend the code.