Word Mail Merge

You want to send the same email letter to many recipients but address each one by name and include custom details. Word’s Mail Merge feature automates this process by pulling recipient data from an external source such as an Excel spreadsheet or Outlook contacts. This article explains how to set up a mail merge from … Read more

Mail merge in Word lets you create personalized documents from a data source like an Excel spreadsheet. But standard merge fields insert the same text for every record. When you need different content based on a condition — such as showing “Mr.” for male recipients and “Ms.” for female recipients — you must use Word’s … Read more

When you run a mail merge in Word, you often need to send documents to only a subset of your data source — for example, customers in a specific city or invoices over a certain amount. Manually deleting rows from your Excel or Access file is risky because it alters your original data. Word provides … Read more

Printing individual envelopes for dozens or hundreds of recipients is tedious and error-prone. Mail merge automates this by pulling names and addresses directly from your Outlook contacts list. This article walks you through the complete process of mail merging envelopes in Word using Outlook as your data source. You will learn how to set up … Read more

When you run a mail merge in Word, records that contain empty fields can create unwanted blank lines, missing addresses, or awkward spacing in your merged documents. This happens because Word keeps the empty field placeholder in the output, leaving a gap where data should appear. This article explains how to use the If…Then…Else field … Read more

When you run a mail merge in Word, numbers from your data source often appear with too many decimal places, missing commas, or incorrect currency symbols. This happens because Word treats numeric data as plain text by default. This article explains how to apply number formatting directly inside mail merge fields using field codes so … Read more

When you run a mail merge in Word, dates from your data source often appear in raw formats like 2023-01-15 or 44563. This happens because Word pulls the underlying serial number or default source format instead of your preferred date style. You need a way to display dates as January 15, 2023 or 15/01/2023 without … Read more

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 … Read more