Rick, this is digging up old posts, I know. But this VB really saved me so much trouble.

I do have one need from this code though, that is, to add 'and' for the last two sets to variables looked up by the code.

Basically, I'm using your code to make a mail merge section for my Word, which is a contract for family signing, so, by looking up Reference numbers in the MasterList, your code helps me generate all the values and complies it into one cell, where I can easily merge to my contract form.

The issue is that I'd like to have 'and' for the last two person's names, which is an essential thing because it is a standardised format of the contract....so if I have 3 names, for example, Michael Jones, Amy Jones, Lincoln Jones, I'd like the cell to display 'Michael Jones, Amy Jones, and Lincoln Jones'

Is there a code that helps detect that it is the last entry and thus add prefix to the final variable?