Mail Merge from Access

[Jeanette]

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?

 

[Doug Robbins - Word MVP]

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.

--
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

 

[Jeanette]

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!