If it looks right, click Finish & Merge to apply this to all the labels.Click Preview Results to see the layout of the first label.Click Update Labels to make format apply to all of the labels.Click Address Block or Insert Merge Field to arrange your data how you want.Browse your files to find your Excel spreadsheet and click Open.Click Select Recipients and Use Existing List.Next select your Avery product number and click OK. Click Start Mail Merge, then Labels, then select Avery US Letter in the drop-down menu next to Label Vendors. Mail Merging without using the Step by Step WizardYou can also click on the Mailings tab at the top of the screen. This should create the fully merged document. If everything looks correct then you can click on Next: Complete the Merge.Ĭlick Edit Individual Labels to open the Merge to New Document window. If there are any other spaces, line breaks, or characters you need to add you can click on Previous: Arrange Your Labels to go back to the previous step and make adjustments. Then click Update All Labels to apply these changes to the entire sheet. In the first label, you can click between each field to add spaces, line breaks and commas. For example, click on First Name and then click Insert, then click on Last Name and then Insert, and so on. Choose which of your columns to merge and in what order by clicking on each field and then clicking Insert one at a time. Then click Next: Arrange your labels.Ĭlick More items and the Insert Merge Field window will open. Make sure the data is correct and click OK. Once you find and open your Excel file, a window will ask you to select a table. Then click on Next: Select Recipients.Ĭhoose Use an existing list and Browse. Then scroll to your product number, click on your product number and click OK. In the Label Options window, make sure that the Printer Information is set to Page Printers, Tray is set to Default Tray, and Label Vendor is set to Avery US Letter. Click Start Mail Merge, then Step by Step Mail Merge Wizard.Ĭlick Labels and then click Next: Starting document. Mail Merge with the Step by Step Wizard in Microsoft WordĬlick the Mailings tab at the top of the screen. Press Ctrl+v to paste the contents of the Clipboard (from step 3) into the new document.First, be sure your Excel spreadsheet has one column for each item you want, such as Name, Address, City, State and Zip Code and that this is in Sheet 1 of the spreadsheet file.Press Ctrl+A to select the entire new document.Continue with the following steps to complete the process of creating the new document with your original labels in the new Avery 5163 format: The new document contains a full set of labels based on the first label in your original document. Word creates a new document using the label format you specified in steps 7 and 8.Īt this point you should have two documents-one that is your original (Avery 5162 format) and one that is your new document (Avery 5163 format). Make sure the Full Page of Same Label radio button is selected.Word closes the Label Options dialog box. In the Product Number list, choose 5163.Using the Label Vendors drop-down list, choose Avery US Letter.Word displays the Label Options dialog box. The Labels tab of the Envelopes and Labels dialog box. Word displays the Labels tab of the Envelopes and Labels dialog box. Click the Labels tool in the Create group.Press Ctrl+c to copy the selection to the Clipboard.Press Ctrl+A to select the entire document.Open the existing document, the one that contains your labels in the Avery 5162 format.If your labels are all the same, then the easiest method of converting to the desired label format is simply to use much of the same process you used to create the labels in the first place. As long as you don't copy the table structure-just the data-you should have no problem. Because you change the table settings to match what is required for the new labels, you should be able to print on them with no problems.Īnother idea is to create a new document consisting of empty Avery 5163 labels and then copy the data from the old Avery 5162 document to the new document. Understanding this, you could easily examine the table settings used in creating Avery 5163 labels and then change the table settings in your old document to match them. It is important, though, to remember that a label document is nothing but a large table that is formatted to match the dimensions of your labels. There are a couple of ways you can approach this problem. She wonders if there is a way to change label size without the requirement of recreating the entire document. The document is intended to be printed using Avery 5162 labels, but Veronica wants to change the document so it uses Avery 5163 labels. Veronica has a document that contains labels, with names already in place.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |