Mail merge into WORD problem

T

The Bodster

I want to export (mailmerge) lots of sets of series of rows from an EXCEL
spreadsheet into a table in WORD. Each time I do this each separate row in
the s'sheet appears as the top line of a new table on separate pages instead
of filling the contents of a table on a single page.
Any ideas?

Cheers,

B
 
E

Earl Kiosterud

Bodster,

It doesn't sound as though mail merge is the solution. It's doing exactly
what it's supposed to do. One row of the Excel table per mail merge
document.

Say in more detail what you want to accomplish.
 
T

The Bodster

Dear EK,

I want to transfer lots groups of 8-10 lines of data (each group showing the
same sort of information) from an EXCEL spreadsheet into a table in WORD.
Basically it's a series of school reports based on inputted data from an
EXCEL s'sheet.

Cheers,

B
 
E

Earl Kiosterud

B,

Since the mail merge will generate strictly one document per table row,
you'd need to get the data into that layout first. A macro could generate
such a sheet from the original table. If this is a one-time project, and
there isn't a large amount of data, it might be most productive to do that
by hand.
 
Top