If you need to use copy and paste to complete your label template, you must remember to make sure that you leave the NEXT RECORD rule in place. This option is NOT available if you have used a saved label template. The Mail Merge Wizard Panel contains a tool (UPDATE ALL LABELS) to do this for you. We recommend adding your design to the first blank label and then using copy and paste to fill in the rest of your template. Repeat this for each of the remaining blank labels OR copy and paste the rule into the remaining blank labels. Click on this and select NEXT RECORD to add the rule to the second label. In the MAILINGS tab at the top of the page, you will see a RULES option. If you have used a saved label template, you will need to add in this rule yourself. Once you have confirmed your list of addresses, the NEXT RECORD rule will appear in all of the blank labels in your template (apart from the first one). You can use this box to sort and filter your addresses – and exclude any you don’t want to use. You will then be shown a list of the addresses that Word has found in your data source. You also need to indicate if your data source has column headers (e.g. a spreadsheet with two or more sheets), you will need to indicate which section contains your addresses. If your data source has multiple sections (e.g. To open an existing list, click on “Use an existing list”, and then browse to and open your saved address list. You can use an existing list, saved Outlook contacts, or type a new list at this moment. This is where you select your data source (list of addresses). Browse to your saved label template and open it. Saved Label Templates – select START FROM EXISTING DOCUMENT and click on OPEN. We’ve written a Template Tuesday guide to creating label templates, which you can view here. Fill in the measurements of your label size and layout, then click OK to create your label template. A4/A5) and click OK.Ĭreate A Label Template – follow the steps above but instead of choosing a code, click on NEW LABEL. Set “Printer Information” to “Page Printers” and choose your “Label Vendor” (e.g. As mentioned above, you can use a compatible template, a Word template you have previously downloaded and saved, or create a new label template.Ĭompatible Template – select CHANGE DOCUMENT LAYOUT and click on LABEL OPTIONS. This is where you select your label template. MAIL MERGE: STEP 2 – SELECT STARTING DOCUMENT To create a set of address labels, you will need to select LABELS from the list of documents. MAIL MERGE: STEP 1 – SELECT DOCUMENT TYPE You will primarily use this panel to set up your address labels. This panel will guide you through the SIX STEPS of the mail merge. This opens the Mail Merge Wizard panel on the right hand side of your screen. Click on START MAIL MERGE and select STEP BY STEP MAIL MERGE WIZARD. Click on the MAILINGS tab at the top of the page.
#Microsoft word label templates 14 per sheet how to#
We recommend using Word’s STEP BY STEP MAIL MERGE WIZARD and this guide will show you how to use the Wizard to create your set of address labels. Word label templates and measurements for all of our label sizes can be found in our Label Templates section. If your label size doesn’t have a compatible code, you will need a saved copy of a suitable Word label template OR the measurements of your A4 labels.
![microsoft word label templates 14 per sheet microsoft word label templates 14 per sheet](https://www.bennetts.com.au/assets/full/AVD-959063.jpg)
![microsoft word label templates 14 per sheet microsoft word label templates 14 per sheet](https://i.ytimg.com/vi/OLQ5j8gcC5Y/maxresdefault.jpg)
Ideally, you should use a compatible template that is built into Word.
![microsoft word label templates 14 per sheet microsoft word label templates 14 per sheet](https://refreshcartridges.co.uk/igloo/wp-content/uploads/2016/03/Circle-Labels.jpg)
You can use an Excel Spreadsheet, Outlook Contact List, Office Address List, Word Data File, Access Database, or Text File. A data source (your list of addresses).This guide will explain how to use Mail Merge to combine a Word label template with a saved list of addresses to create individual address labels. Template Tuesday Presents.how to use Mail Merge to create individual address labels. Or copy the link! How To? – How To Print Address Labels Using Mail Merge In Word