Reply
 
Thread Tools Display Modes
  #1   Report Post  
KristoferMc
 
Posts: n/a
Default Going To A Previous Record in Mail Merge

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
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

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




KristoferMc wrote:
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



  #3   Report Post  
Doug Robbins
 
Posts: n/a
Default

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



  #4   Report Post  
KristoferMc
 
Posts: n/a
Default

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




  #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






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 05:11 AM
Previous version of Mail Merge style d2power Microsoft Word Help 1 December 15th 04 01:56 AM
How do I keep a blank line from printing in a mail merge? Record. Kellye Mailmerge 1 December 8th 04 01:50 AM


All times are GMT +1. The time now is 07:49 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"