Split contents of cell into single names then search for names on different sheet.

I've uploaded a stripped down version of my workbook with and example put into it. The workbook needs to be within that folder for all the macros to work correctly.

If you have a look at the programming you'll see that there are a couple of e-mail macros. The auto mail sub works great, and does everything I want to be able to do when I only have one contact to deal with. But if I have more than one contact then I'm unsure who I'd go about it. If you add a second contact to the contacts list, and select data on the transmittal sheet tab. choose both contacts and the example document then click print to pdf. it will log the data in the next tab - transmittal register. its using this information that I send automatic reminder e-mails. I want to be able to split the distribution coloumn into the names and then search those names on the contacts sheet to return the address for each person mailed to.

I'm sorry it's all very difficult to explain because I've added so many different functions to this workbook and they all tie in with each other. If you have any other questions I'd be more than happy to help and I'm very greatful for your response.

R