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.

Hi

The Excel source table for Word Mail Merge must be on single sheet, have a
single header row, and must not have any gaps. For every document all source
data must be on single row. Unless you define source table as named range,
the sheet with source table must be first (leftmost) in workbook.

You can enter all data on sheets, designed for this purpouse, and have all
data collected into final source table through links. When you do so, it
doesn't matter at all, how are data there placed.


Arvi Laanemets


"MHoffmeier" wrote in message
...
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.

M

I had the same problem and never found a suitable solution. I ended up
using VBA to move the data to Word. The technique I used is basically this:

http://www.dicks-blog.com/archives/2...tomating-word/

It's not quite as slick as a mailmerge, but it works and it's automated. If
you think this is a route you want to take and run into problems, post back.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

MHoffmeier wrote:
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.