View Single Post
  #5   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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

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

"Doug Robbins" wrote:

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