Probably Simple Merge Task

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark B. - 14 Aug 2007 18:48 GMT

Hi,

I'm trying to merge an excel spreadsheet with a word document. The Excel
spreadsheet looks like the following:
Reading Math
Mark 4 6
Joe 5 8
Jane 7 5

I'm trying to print the results on one page (to save paper) so I've added
the merge fields a few times on the document. When I preview the results,
each page simply repeats the same person and results rather than going on to
the 2nd person on the list. The next page of the document does the same
thing for the second person.

I've tried inserting a Next Record command and that hasn't worked. Any
suggestions?

Thanks!

Reply to this Message

Peter Jamieson - 14 Aug 2007 20:00 GMT

In your Mail Merge Main document, before each copy of the merge fields,
insert a

{ NEXT }

field.

(Use ctrl-F9 to insert the {}, then type NEXT between the {})

This field may also appear as <<Next record>> . You should /not/ have one at
the very beginning of your mail merge main document.

Then try merging again...

Peter Jamieson

> Hi,
>
[quoted text clipped - 16 lines]
>
> Thanks!

Reply to this Message

Doug Robbins - Word MVP - 15 Aug 2007 00:24 GMT

Another way to do that would be to use a Catalog (or in XP and later it is
called Directory) type mailmerge main document in which you just set up one
set of the merge fields in the configuration that you want them. Then
execute the merge to a new document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 16 lines]
>
> Thanks!

Reply to this Message

Rate this thread: