I have setup an excel database to mail merge into a contract that is a word
document with fields for subcontractor, project, scope and such. One of the
fields in the contract is a schedule of values that looks like this:
Carpet $20,000
Tile $10,000
Total $30,000
Is it possible to set up a table like this in excel that will be recognized
as one field in the excel database? Could a cell in the database reference
a table in another work sheet? I can get this to work with six fields in a
row, but it becomes hard to proofread, and is further complicated by the
fact that not all contracts have the same number of items in their schedule
of values. I've also tried word-wrapping in the cell, but it comes into
word as a bit of a mess.

Please let me know if the problem is unclear, thanks in advance for the
assistance.