Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
Previous version of Mail Merge style | Microsoft Word Help | |||
How do I keep a blank line from printing in a mail merge? Record. | Mailmerge |