Going To A Previous Record in Mail Merge

[KristoferMc]

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

 

[Graham Mayor]

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.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins]

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

 

[KristoferMc]

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?

 

[Peter Jamieson]

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