This checks the LastName merge field, and if it is empty, the record is skipped and Word proceeds to the next record. Consider the following field code, which could be placed at the beginning of a label: Why would you use such a field? It is very helpful if your data source contains a lot of records that are only partial-for instance, you may have data records that record a first name but not a last name. If the criterion is met, then the merge proceeds to the next record in the data source. This field code checks the contents of a specific field against a criterion that you set. Every other cell in the table should look the same as this base label, with the exception of a field in your labels. What you are looking for right now is the composition of the first label, in the upper-left corner of your table. Center right, center left, upper left, upper right, center bottom, etc etc. You can position the text in just about any postion you want. Microsoft Word is great for label text alignment. A box will appear to the right of cell alignment, with buttons that allow you to change the position of your text. Your document should consist of a table, with each cell of the table responsible for a single label. Step 3 - Selecting The Right Position for Text. When printing labels, the field codes specify where the individual bits of information go that make up each label. On the Mailings ribbon, click Start Mail Merge Step by Step Mail Merge Wizard. The purpose of the Mail Merge Wizard is to get enough information from you that Word can set up the field codes properly. If the codes are incorrect, the merging is not done properly. Merging is accomplished through the use of field codes. Find the Avery Wizard in your list of programs. This should display all the field codes in the document. Open the Windows Start Menu in the bottom-left corner of your screen: Type Programs and Features in the search box at the bottom and then select it from the list near the top of the window. Open the main document-the one that you use to merge with your data.If you are not getting that, then the most likely culprit is the actual main document created in Word. Under Mailings in Microsoft Word click on Start Mail Merge and click on Step by Step Mail Merge Wizard. If you use the standard Mail Merge Wizard, it sets up your labels so that you don't get blanks you only get the labels you want. Quite honestly, this problem should not occur in Word. It seems that the labels she wanted were printing out, but the printing was also kicking out a blank label for every record filtered out of the merge. This opens the Envelopes and Labels panel to the Labels tab. Peggy experienced a problem printing merged labels from a filtered database.
0 Comments
Leave a Reply. |