Given that you only have one line of data, it is difficult to see the whole picture. Is the aim to produce one e-mail message with all the recipient data collated, or several e-mail messages, each with its own data? I suspect the former, though your macro suggests otherwise.

If I suspect correctly then I must further assume that you want to add a raft of recipients (as CC?) and an equal number of attachments?

How EXACTLY do the attachment names relate to the fields in the section from row 9 on?

While you can do that (though I would have to look at the limits) might it not be better to send separate messages - in effect mail merge?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com