Excel VBA Lotus notes many recipients

[Nihongin]

Hello,

I am attempting to automate a file in excel using vba which will send ranegs of a file as attachment in Lotus notes. I have found a Lotus notes vba script on this forum and have tried to modify the code but I became very troubled with my progress.
The file is attached and on control tab there is a box with recpients and, subject and parts of the file I want to send. The problem I have is with recipeints.
The code aim is to start at the left with file name and then pick up the `To1` column, `TO2` column subject and attach the range.
How can I modify the code to loop across to pick up the fields. Originally I could hard code but told to use this method which I am having trouble. Apologies for my poor english and I hope the attached file can make more sense.
Thank you kindry
NG