Printing Problems

Start Word for Mac Mail Merge Labels on a Partially Used Sheet

Ayan MasoodAyan Masood Nov 20, 2026 869 views

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.

Start Word for Mac Mail Merge Labels on a Partially Used 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.
Before you start

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.

Solution 1Recommended

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.

1
Prepare the recipient list

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.

2
Add placeholder rows

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.

3
Set up the label merge

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.

4
Insert the fields

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.

5
Check recipients and preview

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.

6
Test and print

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.

Reserve used positions with placeholder records
Check the preview before printing: Word for Mac and printer options vary by version. If the placeholders do not appear in the recipient list or the preview starts in the wrong position, adjust the source list or filter before printing.
Free Microsoft Office alternative

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.

Edit label documents and recipient spreadsheets in one office suiteOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for a smoother transition from Microsoft OfficeWork with a free, lightweight office alternative
microsoft office alternative - wps office

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.