![]() Most likely, you will need to use the "More Items" option to manually arrange your labels to suit your application. There are some predefined arrangements but those work best when your data is highly conforming.Ĝlick on "Next: Arrange your Labels" in the Mail Merge task pane.You will see > indicators in each of the label boxes of your document except the first label where you will complete your label set up. You can also deselect certain records by eliminating the next to the record to be skipped. The column drop downs filter similarly to Excel's filtered list features by choosing certain criteria. Ĝlick on OK – The Mail Merge Recipients dialog box will display, you can filter your data at this point to print all records or selected records as needed.Make sure there is a in the "First Row contains Column Headers" option, if it applies.If your file contains only one worksheet containing data, this step will be confirmatory. Select the worksheet containing the address data from the "Select Table" dialog box.The "Select Table" dialog box will be displayed. Click on Open, once you have located the Excel file containing your data. Ĝlick on Browse and navigate to where your Excel file is located on your system.Place a tick mark in the radio button next to "Use an Existing List".Ĝlick on "Next: Select Recipients" from the Mail Merge task pane.If it is not, then position it there before you proceed with the next step. Your insertion point should be displayed in the first label box of your document.This is an optional step but I find it helps to see where things will position. ![]() This makes it easier for positioning your text. Ĝlick on the Show-Hide button on the Standard Toolbar to display the non-printing characters.As soon as you click on OK, Word will apply the proper layout for the size label you selected to your document. The most common address label size is Avery 5660. Use that number to determine the correct layout of your label. Generally, the Avery Standard Label product number equivalent is stated on most on the shelf label products. Ĝlick on the link to "Label Options" to select the size and layout of the labels you want to use.Put a tick mark in the radio button next to "Change Document Layout". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |