Feeding Excel Contents into a Word Doc

Apologies in advance folks- I've been searching all morning and have come close to what I think I'm looking for, but not exactly. Issue is, I'm not entirely certain I even have the terminology down, so please bear with me.

In simplest terms as I can put it:

I need to create a proposal template in Word 2007. Portions of the template will never change. The portions that DO change, either by their content or inclusion/exclusion in the document, I'd like to be "fed" by an Excel spreadsheet.

IE: I need to create the relationships between paragraph 'X' in the Word doc and cell 'X' in the spreadsheet, such that if it changes in Excel, you can generate the document based on those changes.

I know this may be a VB thing, an Access thing, an Excel and/or Word Merge thing, etc. and I've even hoped to stumble across software that would generate the appropriate linked docs, but no luck yet.

Any wisdom, even on the correct terms I should be looking for, would be so very much appreciated. Thanks much,

David

Sounds like you want to do the following,
highlight the cells in Excel that you want to be transferred
Go to the spot in the WORD document that you want to paste and use Paste Special > Paste as Link >MS Excel Object.
Try Special pasting it in several ways to see what works best for your situations.

Does that help?

ChemistB

Well... kind of.

I tried that, but found that it's very limiting in formatting. In a perfect world, it would transfer the text, almost as if you'd pasted the characters unformatted and then be able to format that text within the doc.

Thanks for the response!

You do have the option of Pasting Special > Link > As unformatted text.

ChemistB

So you can!

I think I'm getting the hang of this concept...

Thanks ChemistB!