I'm trying to do a mail merge to print to labels. The first field in the document does not contain a { NEXT }
field code, and because of this the records repeat between label pages for example:
Notice how the records shift to the left as the next page is displayed? But how they start over again in an off by one manner?
Now I've tried to fix this by using the first record displayed on a page to see if the page number is 1. If it not on page 1 of the mail merge then it should just move to the next record; otherwise it should just display the first record:
This doesn't work however, because when I do the preview and display the {page} field code, it reports that I am always on page 1 and thus the same behavior continues instead of just moving to the next record on the next page.
Best Answer
Oh okay so it is working right...Microsoft can't make their previews work right in the Mail Merge for 2007, so here is what I did:
Mailings
TabStart Mail Merge
dropdown button.Step-By-Step Mail Merge
, the Mail Merge wizard will appear in the right hand panel.Labels
radio buttonNext: Starting document
Change document layout
Label options...
OK
Next: Select recipients
Use an existing list
Browse
OK
Next: Arrange your labels
More items
, and in the resulting window double click the fields you need until you get to the second line of the address.Insert
tab.Quick Parts
dropdown.Fields...
to insert field codes.Field
dialog from theField names:
double clickIF
{ IF \* MERGEFORMAT }
will appear, delete the\* MERGEFORMAT
part.{ IF
click theMore items...
hyperlink again...{ IF
field type= "" ""
More items...
hyperlink again...{IF { MERGEFIELD "addr2"} = "" "" "{ MERGFIELD "addr2" }" }
More items...
hyperlink (this may not be as easy as it seems depending on the size of your labels).Mailings
tab.Update Labels
, the changes will propagate to all your other labels.Next: Preview your labels
Update Labels
and then ALT+F9 again to get it right...it's not easy to get the spacing right.Mailings
tab click theFinish & Merge
dropdown button.Edit Individual Document
All
radio button and clickOK
.