Word Mail Merge

When you set up a Word mail merge that pulls data from an Excel workbook, the connection works correctly until you refresh a Power Query in that Excel file. After the refresh, Word shows an error saying it cannot open the data source or the merge fields become unreadable. This happens because Power Query transformations … Read more

Running a mail merge in Word is a common task for sending personalized letters, invoices, or marketing materials. But when your recipients speak different languages, a single template cannot serve everyone. You need a method that automatically selects the correct language template for each recipient based on their language preference stored in your data source. … Read more

When you update the source data in an Excel spreadsheet or a database, Word mail merge documents often fail to refresh calculated fields like totals, averages, or IF formulas. This happens because Word stores the last merged values in the document and does not automatically recalculate formulas when the source changes. This article explains why … Read more

When you use Word Mail Merge to create personalized documents such as certificates, ID cards, or product catalogs, you often need each record to display a different image. The standard Mail Merge feature inserts text fields easily, but inserting unique images per record requires a specific workaround. This article explains why Word cannot directly merge … Read more

When you use Word Mail Merge to send emails directly, some recipients report that special characters such as accented letters, em dashes, or smart quotes appear as garbled text like =E9 or =2014. This happens because Word selectively applies Quoted-Printable (QP) encoding to the email body based on the content and the mail client that … Read more

When you run a mail merge in Word, you often need to send letters or emails only to a subset of your data source. The standard filter dialog in Word lets you select recipients based on field values, but it uses AND logic by default. This means all conditions must be true at the same … Read more

When you run a mail merge in Word and select a specific record, the preview pane still shows the first record instead of the one you chose. This problem usually occurs because the mail merge preview is tied to the main document’s field codes, not the selected data source row. The issue can also stem … Read more

When you run a mail merge in Word, blank address lines in your data source can create ugly gaps in the output. For example, a recipient with no apartment number leaves a blank second line, shifting the city and state down. This happens because Word preserves every field even when its source cell is empty. … Read more

When you run a Word mail merge, the page numbers in the preview or final output may restart at 1 for each recipient section. This happens because Word treats each merged record as a new section break, and page numbering is set to restart at section boundaries. The issue is common when merging letters, labels, … Read more

You want to perform a mail merge in Word using an XML file as the data source instead of a standard Excel sheet or Access database. Word’s built-in mail merge wizard expects data in a specific format, but an XML file with a custom schema does not automatically map to merge fields. This article explains … Read more