Vlookup table to find email addresses

Originally Posted by colin7

Would I need to repeat this code for all 40 checkbox click events?

Yes you will, but only the first code, the second code remains as-is.

When you add the extra subcontractors, you will need to modify the code to add the extra emails as well.