Others

Populate Printable Forms from Excel Rows with Word Mail Merge

Emma BrownEmma Brown Nov 18, 2026 869 views

Question details

Populate repeated printable forms or labels from rows in an Excel data table without manually changing macro source ranges.

Populate Printable Forms from Excel Rows with Word Mail Merge
Product
Microsoft Excel and Microsoft Word
Device & OS
not provided
Scenario
Each row of an Excel table contains a record that needs to appear in a printable form or label.
Observed behavior
A data-driven document process should insert each record into the appropriate form or label and continue through the selected rows.
Before you start

Arrange the Excel data with one record per row and a unique header for each column. Save the workbook and check that the printable form has space for the fields you want to insert.

Solution 1Recommended

Use Word Mail Merge to populate forms from Excel

Connect a Word form or label layout to the Excel table and generate a printable document for the selected records.

1
Prepare the form

Open Word and create or open the form layout. On the Mailings tab, select Start Mail Merge and choose Letters for individual forms or Labels for a label sheet.

2
Connect the workbook

Choose Mailings > Select Recipients > Use an Existing List, select the Excel workbook, and choose the worksheet or table containing the records. Confirm that the first row contains headers when prompted.

3
Insert the fields

Click each location in the form and select Mailings > Insert Merge Field to add the corresponding Excel column. For labels, set up the first label and click Update Labels to copy the layout across the sheet.

4
Choose and preview records

Select Mailings > Edit Recipient List to filter or exclude records if needed. Click Preview Results and use the navigation arrows to check how different rows appear.

5
Generate the output

Select Mailings > Finish & Merge, then choose Edit Individual Documents to review the merged output or Print Documents to print the selected records.

Use Word Mail Merge to populate forms from Excel
Label records: When you use Word's label setup and Update Labels, Word adds the Next Record rule so successive labels use successive rows. Preview the sheet before printing.
Create printable forms with WPS Office

Merge spreadsheet rows into printable forms with WPS Writer

Use an Excel-compatible spreadsheet as a data source in WPS Writer, insert merge fields into a form, and generate documents for the selected records.

  1. 1. Prepare the data: Open the workbook in WPS Spreadsheets, make sure each column has a header and each record occupies one row, then save the file.
  2. 2. Open the form and data source: Open or create the form in WPS Writer. On the Mailings tab, choose Open Data Source and select the spreadsheet and its data sheet.
  3. 3. Add merge fields: Place the cursor at each form position and use Mailings > Insert Merge Field to select the corresponding spreadsheet column.
  4. 4. Preview and merge: Use the Mailings tab to preview the records, then choose Merge to New Document to review and print the completed forms.
Populate repeated forms from spreadsheet recordsOpen Microsoft Excel XLSX spreadsheets and Word DOCX documentsPreview merged fields before producing the final documentUse a familiar document and spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How should I arrange the Excel data for Mail Merge?

Put a unique field name in each column header and one complete record in each row. Save the workbook before selecting it through Word's Mailings > Select Recipients > Use an Existing List.

Can I print forms for only some of the Excel rows?

Yes. In Word, select Mailings > Edit Recipient List to filter the records or clear the checkboxes for recipients you do not want to include.

How do I make each label use a different Excel row?

Choose Labels under Mailings > Start Mail Merge, add fields to the first label, and click Update Labels. Word adds Next Record rules to the remaining labels; use Preview Results to check them.

Do I need a macro to create a form for every record?

No. Word Mail Merge can use the Excel table as its recipient list and generate a form for each selected row through Mailings > Finish & Merge.