Mail Merge-Tables

[MHoffmeier]

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.

 

[Arvi Laanemets]

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

 

[Dick Kusleika]

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/2004/08/13/automating-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.