Going To A Previous Record in Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KristoferMc - 17 Jan 2005 09:49 GMT

Hello,

I need to find a way of asking word to go back 4 record in a set of lables.
For example on an 8 per page label setup, i would like the records 1-4 to
appear on the first four labels and then 1-4 duplicate from labels 4-8. What
i am effectively looking for is a statement which is the opposite of {next
record}.

thanks in advance for all your assistance.

kristofer

Reply to this Message

Graham Mayor - 17 Jan 2005 10:29 GMT

Data files are processed sequentially.
The best you are likely to achieve readily is to remove every other next
record field which will produce the labels in pairs, but immediately
following one another.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hello,
>
[quoted text clipped - 7 lines]
>
> kristofer

Reply to this Message

Doug Robbins - 17 Jan 2005 10:34 GMT

The only way to do this with mailmerge would be to execute the merge twice
with two specially set up main documents. In the first document, delete the
merge fields from the 5th through 8th labels and in the second, delete them
form the 1st through 4th labels and the <<Next>> field from in front of the
first mailmerge field in the 5th label.

After executing the first merge, you will need to re-load the sheets into
the printer in the correct order for the second.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 9 lines]
>
> kristofer

Reply to this Message

KristoferMc - 17 Jan 2005 10:43 GMT

the merge is a little more complex than the example i used, so the two run
option is not applicable.

so are you saying that there is no function in word that allows you to
return to a previous record?

> The only way to do this with mailmerge would be to execute the merge twice
> with two specially set up main documents. In the first document, delete the
[quoted text clipped - 17 lines]
> >
> > kristofer

Reply to this Message

Peter Jamieson - 17 Jan 2005 11:29 GMT

> so are you saying that there is no function in word that allows you to
> return to a previous record?

There is no such function.

Another approach you can try is to store the values of the fields you are
using in bookmarks using SET fields, and re-using them with REF fields.

e.g. let's suppose you want to repeat the first two labels rather than the
first four, and your label uses field f. Try something like

label 1:
{ SET F1 { MERGEFIELD F
}{ MERGEFIELD F }

label 2:
{ NEXT }{ SET F2 { MERGEFIELD F
}{ MERGEFIELD F }

label 3:
{ REF F1 }

label 4:
{ REF F2 }

Peter Jamieson

> the merge is a little more complex than the example i used, so the two run
> option is not applicable.
[quoted text clipped - 29 lines]
>> >
>> > kristofer

Reply to this Message

Rate this thread: