Creating a Custom Word Document Based on an Excel Template

Afternoon all,

We have an excel document that lists all of the services available and customers use drop down boxes to select what they require. We have a separate Word document that describes what each service entails. Is it possible, presumably using VBA, to create a custom abridged Word document that only shows descriptions for the services that the customer wishes to buy? Basically if the service isn't required I would like the relevant line/paragraph removed from the Word doc. There's a natural link in that the Excel doc contains the same service references as the Word doc. I should be fairly flexible on the structure of the Word doc if it aids the solution (and looks ok)? I was potentially thinking of using a custom list to itemise the services?

Also, could the Word doc be embedded as part of the Excel doc or would they need to be stored separately? I think an embedded solution would better suit our need but I'm happy to hear what options we have available.

If it helps, I've attached two sample workbooks. I hope that explains my situation clearly enough but if you have any questions just give me a shout.

Cheers,

Snook