Using Excel to populate fields in a Word document

[wilgrant]

I am looking for ideas using VBA to populate fields in a Word docuement from values in an Excel worksheet cells. I know I can do this with the Mail/Merge function of Word, however, that forces me to have an Excel spreadsheet that is wider than I want to present to the user, from a visual perspective. I would prefer to be able to access cells in a spreadsheet in one column. What I hope to work with is a Word document that has standard text with the occassional keyword or field code interspersed, and use the values in the Excel spreadsheet to populate replace the keywords/field codes when my macro is executed.

Any help would be appreciated.