Word Mail Merge

You have a Word mail merge document with a hyperlink field, but when you finish the merge, the resulting hyperlinks appear as plain text and do not open a web browser when clicked. This problem occurs because Word does not automatically update the hyperlink field codes in the merged output; the field codes remain in … Read more

When you run a mail merge in Word using an Excel file, dates from your spreadsheet often appear as numbers like 45123 instead of January 15, 2024. This happens because Word reads Excel date values as serial numbers and does not automatically apply the date format you set in Excel. This article explains how to … Read more

When you run a mail merge in Word, the merge may skip rows in your Excel data source that appear to be empty. This causes missing records in the final merged document, such as letters or labels that should have been created. The root cause is often that Excel treats blank cells differently from truly … Read more

When you run a mail merge in Word, you often need to show different text, hide empty fields, or skip certain records based on data conditions. Manually editing each merged document defeats the purpose of automation. Fortunately, Word provides built-in conditional field codes that handle IF, THEN, ELSE logic without writing any VBA code. This … Read more

When you run a mail merge in Word using an Excel spreadsheet as the data source, number fields such as prices, quantities, or percentages may appear with unexpected extra decimals — for example, 25.0000 instead of 25 or 19.990000000000002 instead of 20. This happens because Word interprets numeric data from Excel as floating-point values rather … Read more

You need to send personalized emails with attachments that differ for each recipient. The standard Word mail merge feature sends the same document to everyone. It does not natively attach separate files per recipient. This article explains how to use a Directory merge combined with a VBA macro to attach unique files from a folder … Read more

When you run a mail merge in Word, each record from your data source should appear on a separate page or section. Instead, you see the same record repeated across multiple pages, making the merge results unusable. This problem usually occurs because the Next Record rule is missing, misplaced, or because the data source contains … Read more

You need to send personalized documents to many recipients, but each person must receive their own PDF file. A standard mail merge in Word produces a single merged document with all records on separate pages. Splitting that combined PDF manually takes too long when you have hundreds of recipients. This article explains how to use … Read more

When you run a mail merge in Word using an Excel spreadsheet as the data source, postal codes that start with one or more zeros often appear without those leading zeros. A code like 01234 becomes 1234, which causes returned mail and delivery failures. This happens because Excel interprets postal code columns as numbers and … Read more

You set a custom time format in your Word mail merge document, but the final output shows times in a 24-hour style instead of the 12-hour format you specified. This problem occurs because Word’s merge engine reads the raw time value from the data source and applies its own default formatting, ignoring the format switch … Read more