How to Use Mail Merge for ID Cards in Word

Creating ID cards for employees, students, or event attendees usually requires a template and a list of names and photos. Word's mail merge feature can automate this process, so you do not have to type each card manually. This article explains how to set up a mail merge for ID cards using a data source like Excel. You will learn to create the card layout, link your data, and print or save all cards at once.

How Mail Merge Works for ID Cards

Mail merge in Word is normally used for letters and envelopes. For ID cards, you use the same engine but with a label-style layout. The label layout creates a grid of identical cards on a single page. Each card can contain text fields such as name, department, and ID number. You can also include a photo by using the Include Picture merge field.

Before you start, prepare two items. First, a data source. Use an Excel spreadsheet with columns for each data point. For photos, include a column with the full file path to each image, for example C:\Photos\JohnDoe.jpg. Second, have a blank Word document ready. You will build the card template inside the label grid.

Steps to Set Up Mail Merge for ID Cards

The process has three phases: define the label grid, design the card layout, and run the merge. Follow these steps in order.

Phase 1: Create the Label Grid

1. Open a blank Word document
   Start with a new document. Do not add content yet.
2. Go to Mailings > Start Mail Merge > Labels
   In the Label Options dialog, choose your label vendor and product number. For ID cards, select a size that fits your card dimensions. Common choices are Avery 5395 or 8395 for business cards. Click OK.
3. View the grid
   Word fills the page with a grid of empty label cells. Each cell represents one ID card. If you do not see the gridlines, click the Table Design tab and choose View Gridlines.

Phase 2: Design the Card Layout

You will design one card in the first label cell. Word will copy that layout to all other cells during the merge.

1. Click in the first label cell
   Place your cursor in the top-left cell of the grid.
2. Insert a photo placeholder
   On the Insert tab, click Pictures and choose This Device. Select a sample photo to use as a placeholder. Resize it to fit the card. Later, you will replace it with a merge field.
3. Add text fields
   Type the static labels such as Name: and ID:. Leave space for the merge fields.
4. Connect to your data source
   Click Mailings > Select Recipients > Use an Existing List. Browse to your Excel file and select the worksheet. If your data includes a header row, check First row of data contains column headers.
5. Insert merge fields for text
   Click Mailings > Insert Merge Field. Choose the field for the name, then press Space or Enter. Insert the ID field. Repeat for any other text fields. The fields appear as «Name» in the document.
6. Insert merge field for the photo
   Delete the placeholder photo you inserted earlier. Click Insert > Quick Parts > Field. In the Field dialog, select IncludePicture from the list. In the Filename or URL box, type a temporary path like C:\temp.jpg. Click OK. The field appears as { INCLUDEPICTURE }. Right-click the field and select Toggle Field Codes. You will see { INCLUDEPICTURE "C:\temp.jpg" }. Replace the quoted path with { MERGEFIELD PhotoPath } where PhotoPath is the column name in your Excel file. The final code looks like { INCLUDEPICTURE "{ MERGEFIELD PhotoPath }" }. Press F9 to update the field.

Phase 3: Run the Merge

1. Preview the results
   Click Mailings > Preview Results. Word shows the first card with live data. Use the arrow buttons to step through each record.
2. Update the photo fields
   If photos do not appear, press Ctrl + A to select all, then press F9 to refresh fields. If photos still do not show, save the merged document and reopen it.
3. Finish the merge
   Click Mailings > Finish & Merge > Edit Individual Documents. In the dialog, choose All and click OK. Word creates a new document with all ID cards filled in.
4. Print or save the cards
   Print the merged document on card stock. Or save it as a PDF by choosing File > Save As and selecting PDF.

Common Problems and Solutions When Merging ID Cards

Photos do not appear after merge

This is the most frequent issue. The IncludePicture field stores the path as text, not the actual image. After merging, Word does not automatically load the images. To fix this, press Ctrl + A to select all content in the merged document, then press F9 to update all fields. If that fails, save the merged document, close it, and reopen it. Word will then load the images.

Card layout shifts to the next page

If your card design is too large for the label cell, content overflows to the next cell or page. Reduce the font size or resize the photo. Use the ruler to check the cell dimensions. The maximum width and height are set by the label product you selected.

Excel data is not recognized

Word requires the Excel file to be closed during the merge. If the file is open, Word may not read it. Close Excel before selecting the file in Word. Also ensure the worksheet name does not contain spaces. Rename the sheet to a single word like Sheet1.

Merge fields show as blank in preview

This happens when the field name does not match the column header in Excel. Open the data source and verify the exact spelling. Click Mailings > Insert Merge Field again and pick the field from the list. Do not type the field name manually.

Mail Merge for ID Cards: Label Layout vs Table Layout

Item	Label Layout	Table Layout
Setup method	Mailings > Start Mail Merge > Labels	Insert > Table, then use mail merge in each cell
Card alignment	Automatic grid based on label dimensions	Manual alignment with table cells
Photo handling	Requires IncludePicture field code	Requires IncludePicture field code
Number of cards per page	Determined by label product	User-defined by table rows and columns
Ease of reuse	High – save the label document as a template	Medium – table dimensions may change with data

After completing the merge, you can print all ID cards at once or save the merged document as a PDF for digital distribution. For future batches, reuse the same label document with a new data source. To speed up photo loading, store all images in a single folder and use relative paths in the Excel column. This avoids broken links when moving the files.