Problems merging many records on a single page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl Mercier - 15 Jan 2005 20:27 GMT

Hi guys,

I'm trying to do a simple merge from an Excel file in Word 2003 and it's
giving me headaches. The problem is that I need to merge 5 different
records per page (5 customers per page with their address and so on).

So, my Word document looks like this:

-START OF PAGE-
<ADDRESS BLOCK><NEXT RECORD>
<ADDRESS BLOCK><NEXT RECORD>
<ADDRESS BLOCK><NEXT RECORD>
<ADDRESS BLOCK><NEXT RECORD>
<ADDRESS BLOCK>
-END OF PAGE-

Word seems to go to the next record automatically on page breaks so I
omited the last one.

I get weird results however. Here's what I get (record IDs):

PAGE 1: 1,3,4,5,6
PAGE 2: 2,4,5,6,7
PAGE 3: 3,5,6,7,8

See the pattern? Something's wrong. Of course, I want record 1-5 on
page 1, 6-10 on page 2 and so on.

Anyone has an idea what could be causing the problem? Also, is there a
way to turn off "next record on page break"? I think that might be
causing the problem.

Thanks!

Carl

Reply to this Message

Doug Robbins - 16 Jan 2005 00:27 GMT

I would suggest that you use a Directory type mailmerge for which you need
only insert one set of MergeFields. If you locate them inside a one row,
one column table with the row height set to an exact value that will only
allow 5 rows to a page, you will get what you want when you execute the
merge. Turn off the table borders if you don't want them (Ctrl+Alt+U).

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi guys,
>
[quoted text clipped - 31 lines]
>
> Carl

Reply to this Message