Mailmerge problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frustrated - 26 Apr 2007 16:40 GMT

I am doing a simple mailmerge to six lables on a self made form. I have the
data in a single column in an excel spreadsheet. I added the merge field
"Name" and "next record" in each label on the page. The problem comes when I
merge the document. It appears to leave off one name per page. Is there
some command I need to tell the program to start a new page and not loose a
data name. I have 147 names in the data file and am only receiving 126
labels. Any suggetions.

Signature

Frustrated

Reply to this Message

Peter Jamieson - 26 Apr 2007 16:59 GMT

Remove the <<Next record>> from label 1. Word automatically moves tot the
next record each time it processes the "label sheet".

Peter Jamieson

>I am doing a simple mailmerge to six lables on a self made form. I have
>the
[quoted text clipped - 6 lines]
> data name. I have 147 names in the data file and am only receiving 126
> labels. Any suggetions.

Reply to this Message

Frustrated - 27 Apr 2007 19:52 GMT

-- Deleting the "next Record" from the first label in the master document
corrected some of my problem. It seems now I am still missing one data
sequence per page. It seems to be skipping over one when it goes to the next
page. Is there some command that I need to enter so that when a new page is
created and filled that I don't loose a recipient?

Frustrated

> Remove the <<Next record>> from label 1. Word automatically moves tot the
> next record each time it processes the "label sheet".
[quoted text clipped - 10 lines]
> > data name. I have 147 names in the data file and am only receiving 126
> > labels. Any suggetions.

Reply to this Message

Doug Robbins - Word MVP - 27 Apr 2007 21:22 GMT

Where do you have the Next Record fields? The correct place is to have one
before the first mergefield in each of the labels in the mail merge main
document except for the first 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

> -- Deleting the "next Record" from the first label in the master document
> corrected some of my problem. It seems now I am still missing one data
[quoted text clipped - 23 lines]
>> > data name. I have 147 names in the data file and am only receiving 126
>> > labels. Any suggetions.

Reply to this Message

Rate this thread: