Mail merge from Excel missing every 5th record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lindy Flynn - 11 Mar 2008 18:59 GMT

HELP, this is the second large mail merge we've done, from different DB that
is excluding every 5th record. (Last time it was every 4th record). When we
put the fields into the document - which is 4 postcards to a page, we did it
field by field, and added next record at the end of each address.

Any ideas??

Thanks, Lindy Flynn, Flagstaff Arizona

Reply to this Message

Doug Robbins - Word MVP - 11 Mar 2008 20:58 GMT

You do not need the <<Next Record>> at the end of the fourth address as Word
automatically goes to the next record at the beginning of each sheet. The
normal place for that field is before the first merge field in each label
EXCEPT for the first one on the sheet, but I guess you could say that after
each address is before the first mergefield of the next 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

> HELP, this is the second large mail merge we've done, from different DB
> that
[quoted text clipped - 7 lines]
>
> Thanks, Lindy Flynn, Flagstaff Arizona

Reply to this Message

Lindy Flynn - 11 Mar 2008 21:54 GMT

THANK YOU DOUG!!!
That was it, using the next field on the first three cards on the page, and
leaving it off the last worked. Yeah! and Thanks for the info. Lindy

> You do not need the <<Next Record>> at the end of the fourth address as Word
> automatically goes to the next record at the beginning of each sheet. The
[quoted text clipped - 13 lines]
> >
> > Thanks, Lindy Flynn, Flagstaff Arizona

Reply to this Message

Rate this thread: