Directions for preparing data in Excel to print Labels (#preparation) If you are using XL2000, move the tab for the sheet to the far left and create a name for the data: i.e. Select A1:G50 then supply a name (ziplabels) in the name box to left of formula bar. This will work in prior versions also.
. Click Format in the upper right of the Pages window to open the formatting menu on the right side. Then, click the More tab. On our envelope, highlight each placeholder text, starting with FIRSTNAME. In the top menu, click Format Advanced Define as Placeholder Text.
In the formatting menu at the bottom, under Script Tag, type in a name for this placeholder text field. In this example we use FIRSTNAME. Repeat step 4 for each placeholder text item that will correspond to data that will be imported from the spreadsheet: LASTNAME, STREET, CITY, STATE, ZIP. Next to 1 in the app, click the dropdown menu and choose Selection of Numbers Table.
Click Import. The first row will be pulled in and displayed. Select the first item imported—in this case it is the name James. Next to 2 in the app, click the dropdown menu and choose the placeholder tag FIRSTNAME (this is the first placeholder text item we defined). Repeat steps 2 and 3 for each item imported until all items are assigned a placeholder tag.
![How To Use Mail Merge Manager For Address Labels On Mac With Excel How To Use Mail Merge Manager For Address Labels On Mac With Excel](/uploads/1/2/5/4/125400056/408519714.png)
![Address Address](/uploads/1/2/5/4/125400056/519475239.jpg)
For example, select 'Jones' and then choose LASTNAME from the dropdown.
I'm trying to do a mail merge in Excel for labels. I've created an Excel address list with the data, then opened Word and completed every step in the Mail Merge Manager correctly for merging labels from the Excel spread sheet into the label format in Word. When I do a 'preview' of the label sheet before printing it shows that the whole label page consists of all the fields, i.e.: Name, Address, City, State Zip Code - it's not picking up the actual data from the spread sheet. There are no names and addresses appearing on the label sheet.
Why is this happening? Is there something wrong with my data source - the excel spreadsheet? It doesn't seem to be pulling the data from the spreadsheet apart from the fields.