Mail Merge from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeanette - 24 Aug 2007 17:56 GMT

I am trying to run a merge in Word, when I finalize the merge, some of the
records are missing, in fact, the records missing are those at the page
break. So for example if I have 51 client rows of unique information, only
26 are being merged to the letter. How do I fix this?

Reply to this Message

Doug Robbins - Word MVP - 24 Aug 2007 21:45 GMT

I assume that you are doing a label type mail merge. With such a merge, in
the mail merge main document, there should be a <<Next Record>> field BEFORE
the first merge field on each label EXCEPT for the first label on the page.

It is not required for the first label because Word automatically indexes to
the next record when a page break occurs.

From you description, you have the <<Next Record>> after the mergefields on
each label. You will probably be able to get by if you remove it from the
last label.

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

>I am trying to run a merge in Word, when I finalize the merge, some of the
> records are missing, in fact, the records missing are those at the page
> break. So for example if I have 51 client rows of unique information,
> only
> 26 are being merged to the letter. How do I fix this?

Reply to this Message

Jeanette - 24 Aug 2007 22:12 GMT

Thanks Doug ~

You are fabulous! ! ! I tried it without the <<NextRecord>> at the page
break and it worked like a charm!

I appreciate the support I receive from this website and use it frequently!

> I assume that you are doing a label type mail merge. With such a merge, in
> the mail merge main document, there should be a <<Next Record>> field BEFORE
[quoted text clipped - 12 lines]
> > only
> > 26 are being merged to the letter. How do I fix this?

Reply to this Message

Rate this thread: