Fill Word from Excel with data

[Audiguy]

Hey guys,
I tried to search but couldn't find anything related so I'm sorry if this has already been covered. I want to fill in some date in excel, and check a few boxes and have word fill in the data I write in, and in other areas see if information is relevant and fill it in. I have included a rought word and excel form.

To explain from the forms. I want the Project name, address supervisor work dates etc on the word form to fill in from the info in excel. The trickier part is for tasks. I want it to check to see if a fruit is present, and insert a small summary of care that will be written into each fruits summary box. If seed is checked (or yes, however it makes it easier) then the blanket statement about seeds will go right in front of that fruits summary, and that goes for all fruit. Attached find the Excel form, the start word form and an example of what I hope the word doc would look like when auto filled.

Thanks.

[Audiguy]

I just wanted to add that I have tried using mail merge in Word, but I'm not sure how to configure it to meet my needs, but it does seem like it could fit my needs somehow.

[protonLeah]

Those forms don't have to be don in Word, they can be tabs in the same worksheet, then you can use lookups and validation to fill in the blanks. If that's something you can work with, I could have a sample maybe Friday???