Macro to send multiple attachments to several recipients

Good Afternoon

I have tried to set up a macro that sends two files by e mail to a list of recipients, I was pretty much there but it seems to have some errors so think it would be best to go back to the drawing board.

Basically this is how I have my sheet set up

In Cell A1 I have the file names I want to send separated by “ ; ”

In cells B1:B15 I have the e mail addresses of the recipients I want to send the e mail to

In Cells C1:C2 I have the source of the files that I want to send (C1 is the source of the first file in A1 & C2 is the source of the second file in A1 )

I want to be able to send the two attached files by e mail to all the recipients in cells B1:B15

If someone would be kind enough to provide a code it will stop me pulling my hair out.

Here is my code I was working on

I can get it to work when there is one recipient in cell B1 but as soon as I ad multiple recipients it doesnt seem to send anything.

Please Login or Register  to view this content.