Attaching files to an email

I need to find a way to attach files (word docs, pdf, excel workbooks) to an email with varying recipients & personalization of the email.


A9:C19 contains the variable data. The email message itself can be hard written and will be the same for all recipients.

Finally i want the ability to attach up to 8 files, whose locations on the drive are listed by hyperlink in H1:H8.

Thanks - This looks like it may work. I will run it and let you know. Appreciate it.