I am trying to autofill forms using a word document and an excel sheet. I'm using mail merge to fill in the blanks of the form, but then I want something to run through checking values in excel and check the appropriate check boxes on each form. For example, if the score in A2 is greater than 200, it will check the appropriate box on form 1. Then it will move to A3 and if that score is less than 50, it will check the appropriate box on the second form. Then it will keep going until all forms are filled.

I'm kind of a noob at VBA, so help is greatly appreciated. Let me know if you need a more detailed explanation of what I'm trying to do.

Thanks