Hello all,
I need to fill information into a word template or document from an excel document much like a form letter. The issue i'm having is that, unlike most form letters, I don't have a compiled data set in a single excel document. Each excel file is an individualized bidding form that compiles numbers and spits out bids for labor and materials. Rather than copying and pasting all of the data on each bid, I'd like those values (always in the same cell locations) to populate an associated word document from a template.
There are also bits of language that commonly need to be included like "Contractor not responsible for delays due to inclement weather" and "All painting must be done above 45 degrees Fahrenheit". Not all of these need to be included on every job, so it would be nice to be able to select certain ones from the list and have them also populate into the word document automatically. I'm ok with checkboxes, radio buttons, or even changing individual cells from 0 to 1 to get this functionality.
Any and all help is appreciated, Please let me know if i left out any information you need.