Once the fields have been updated, your Word doc should look something like this. Now we need to copy these fields to all the remaining labels on the page. Once you've picked all your fields, it should look something like this. Make sure you include spaces, enters, commas as you want them to appear. You only need to do this to the first label. Use the Insert Merge Field button to select the fields in your Excel file and add them to the label. Now you need to tell Word which fields you want and in what order. 
Once your list has been selected, your Word screen will look like this.In the next dialog box, select the sheet in Excel that contains the list.Use the dialog box to browse to the Excel file and select it and click Open.In the Mailings ribbon, choose Select Recipients.Use an Existing List (this is where we will locate the Excel file).
You will now see on your Word screen, a layout of all the labels, empty. In the dialog box, choose the labels you will use (the most common is 5160) and click OK. In Word, go to Mailings.Start Mail Merge.Labels. Step 3: Create the Word file, Complete Merge and Print The most common address label to use is a 5160 label size. It's important to know before you start the size of labels you are going to use so you can set the document up properly. Step 2: Find the labels you will Use (size) For example, first name, last name, address, city, state, and zip. In simplest form you will gather information into a simple spreadsheet that looks something like this, with separate columns for each piece of information. Whether it's a shower, wedding, graduation, newsletter, business announcement or some other reason for mailing to a group, you probably have or have gathered a list of names and addresses and need to get them into labels. Whether it's for work or for personal reasons, odds are at one time or another - you'll need to print out labels with mailing addresses. Print Mailing Labels in Word from an Excel list
0 kommentar(er)
