Start Word for Mac Mail Merge Labels on a Partially Used Sheet
Question details
The user needs to print mail merge labels from filtered Excel data, starting at the first unused position on an Avery label sheet.

- Product
- Microsoft Word for Mac and Microsoft Excel
- Device & OS
- macOS
- Scenario
- A partially used Avery label sheet will be used to print labels for selected Excel recipients.
- Observed behavior
- The merge should leave used label positions blank and place the selected recipients in the remaining positions.
Find the Avery product number and count the used label positions in the order Word fills the sheet. Check your printer's guidance on refeeding label sheets and avoid sheets with exposed adhesive or damaged labels.
Reserve used positions with placeholder records
Use placeholder records to leave the used positions blank while merging the selected Excel recipients.
Placing the cursor in an unused label does not necessarily tell Word to skip earlier positions during a full mail merge. Placeholder records make those positions explicit.
In Excel, apply the intended filter and copy the selected recipients, including column headers, to a separate worksheet. Check that the copied list contains only the recipients you want to print.
In the new worksheet, insert one row above the first recipient for each used label position. Leave the address fields empty in those rows, but enter a value such as Skip in a separate helper column so the rows are not completely empty. Save and close the workbook.
In Word for Mac, choose Mailings > Start Mail Merge > Labels. Select the Avery product number that matches your sheet, then use Mailings > Select Recipients to open the prepared Excel worksheet.
Click the first label and use Mailings > Insert Merge Field to add the address fields. Do not insert the helper column. Select Mailings > Update Labels to copy the layout to the other labels.
Open Mailings > Edit Recipient List and confirm that the placeholder rows and intended recipients are selected. Remove or adjust any Word filter that excludes the placeholders. Choose Preview Results and verify that used positions are blank and the first recipient appears in the first unused position.
Use Mailings > Finish & Merge to print a test on plain paper. Hold it against the label sheet to check alignment and feed orientation, then print on the label sheet if the test is correct.

Work with label documents and recipient lists in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files into WPS Office; it does not change Word for Mac's mail merge settings.

Frequently Asked Questions
Can I just click the first unused label before merging?
Clicking an unused label does not necessarily make a full mail merge skip earlier positions. Add placeholder recipient rows and use Mailings > Preview Results to confirm where the first real recipient appears.
Will Word automatically use the filter applied in Excel?
Do not assume the Excel filter controls Word's recipient list. In Word, open Mailings > Edit Recipient List and check the selected records and any Word filters before printing.
Why do the placeholder rows need a helper value?
A value in a separate helper column keeps each placeholder row from being completely empty. Leave the address fields blank and do not insert the helper field into the label layout.
How do I check that the labels will line up?
After checking Mailings > Preview Results, print a test on plain paper and hold it against the label sheet. Check both alignment and printer feed orientation before using the Avery sheet.




