Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jeanette Jeanette is offline
external usenet poster
 
Posts: 17
Default Mail Merge from Access

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge from Access

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" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jeanette Jeanette is offline
external usenet poster
 
Posts: 17
Default Mail Merge from Access

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!


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge from Access scubadiver Mailmerge 2 March 22nd 07 01:14 PM
Access and ZIP+4 mail merge Leppy99 Mailmerge 1 December 12th 06 04:33 AM
word opens access in mail merge. Access is already opened.=twice Sherri Mailmerge 1 February 11th 06 05:59 PM
Mail merge with an .mde access db Warrio Mailmerge 1 June 16th 05 01:20 PM
access mail merge jimmy Mailmerge 1 May 12th 05 04:40 PM


All times are GMT +1. The time now is 08:47 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"