Business Letter Mail Merge: Personalized Letters in Word

A business letter mail merge produces one finished letter per customer from a single Word template and an Excel list. The parts that change per recipient are the inside address, the salutation, a few values in the text (customer number, amount, date) and sometimes whole paragraphs. This guide shows how to set up each of those so the letters read as if they were written one by one, and how to choose between printing, PDF and email at the end.

The examples use Microsoft Word with an Excel list. If you need the basic clicks first (connecting the list, inserting a field, Finish & Merge), see the Mailings tab guide.

Which parts of a business letter to personalize

• Letterhead: the same for everyone. Put it in the header so it repeats on every page.
• Date: usually the same for everyone. Type it as plain text rather than inserting an automatically updating date, so a letter you reopen next month still shows the day it was sent.
• Inside address: personalized (name, job title, company, street, city, postal code, country).
• Reference or subject line: often personalized, for example "Your account 10482".
• Salutation: personalized, and the part that most often goes wrong.
• Body: mostly fixed text, with individual values and optional paragraphs.
• Closing and signature: fixed, or personalized when different people sign for different customers.

The data behind the letters

Give every piece of the letter its own column. This example list covers everything used below:

Title	FirstName	LastName	Company	Street	City	ZIP	CustomerNo	Balance	Manager
Dr.	Anna	Becker	Becker Dental	12 Elm Street	Portland	97205	10482	0	Laura Chen
Mr.	James	Wilson	Wilson & Sons	7 Harbor Road	Seattle	98101	10519	420.00	Mark Ellis
	Alex	Morgan		301 Hill Avenue	Denver	80203	10533	0	Laura Chen

Note the third row: no title and no company. Real customer lists always have gaps like this, and the letter has to handle them. Header row, text versus number columns and ZIP codes are covered in detail in our guide to preparing Excel data for a mail merge.

The inside address

You have two options:

• Address Block (Mailings tab): inserts the whole address as one field and leaves out empty lines, so Alex Morgan's letter has no blank line where the company would be. In its dialog, choose the name format, tick Insert company name, and set the country rule to Only include the country/region if different than your own country. If anything lands in the wrong place, use Match Fields to tell Word which column is which.
• Separate merge fields: full control over the layout (job title on its own line, an "Attn:" line), but empty fields leave empty lines unless you wrap them in an IF field, as shown in the Mailings tab guide.

If you send in window envelopes, check the address position against the envelope window once, in a printed test letter. Then there is no separate envelope run.

The salutation: by title, gender or first name

The quick way: Greeting Line

Greeting Line builds "Dear Dr. Becker," from the title and last name, and uses a fallback such as "Dear Sir or Madam," when the name is missing. It is fine for simple lists. Its weakness is the middle case: a row with a name but no title can come out as just "Dear Morgan,", which reads oddly in a business letter.

Better: an IF field on the Title column

An IF field lets you write the salutation rules yourself. With a title: "Dear Dr. Becker,". Without a title: "Dear Alex Morgan,".

{ IF "{ MERGEFIELD Title }" = "" "Dear { MERGEFIELD FirstName } { MERGEFIELD LastName }," "Dear { MERGEFIELD Title } { MERGEFIELD LastName }," }

To build it, press Ctrl+F9 for each pair of braces (braces typed on the keyboard do not work), type the text between them, and insert the MERGEFIELD parts with Insert Merge Field or by typing them inside their own Ctrl+F9 braces. Press Alt+F9 to switch between the code and the result, then check all three rows with Preview Results.

Salutation by gender

If your list has a gender column rather than titles, the same pattern works:

{ IF "{ MERGEFIELD Gender }" = "F" "Dear Ms. { MERGEFIELD LastName }," "Dear Mr. { MERGEFIELD LastName }," }

Be careful with this one. Every row without an "F" becomes "Mr.", including blanks and anyone who prefers neither. A Title column filled from what customers told you, combined with the first-name fallback above, avoids those mistakes. The simplest alternative is a Salutation column in Excel that already holds the full greeting for each row.

Conditional paragraphs with IF rules

Business letters often contain text that only some recipients should get: a payment reminder, a note for customers in a certain region, an offer for a customer segment. Use Rules > If...Then...Else on the Mailings tab:

1. Click where the optional paragraph should go.
2. Choose Rules > If...Then...Else.
3. Set Field name to Balance, Comparison to Greater than, Compare to 0.
4. In Insert this text, type the reminder paragraph. Leave Otherwise insert this text empty.
5. Click OK and preview James Wilson's letter (balance 420.00) and Anna Becker's (balance 0).

The dialog only accepts plain text. To add the amount or formatting, press Alt+F9 and edit the field directly. The amount itself is a nested merge field with a number format:

{ IF { MERGEFIELD Balance } > 0 "Our records show an open balance of ${ MERGEFIELD Balance \# "#,##0.00" } on account { MERGEFIELD CustomerNo }. Please settle it within 14 days." "" }

You can select text inside the quotes and make it bold or change the font like any other text. Keep each rule to one decision. If a letter needs many variations, it is usually clearer to split the list and use two templates.

Closing and signature

If one person signs every letter, the closing is plain text: "Kind regards," followed by the name, title and, if you like, a scanned signature image placed in the template once. If different people sign for different customers, add their name (and title) as columns, here the Manager column, and insert them as merge fields under the closing. A different signature image per recipient is hard in Word: it needs INCLUDEPICTURE fields that point to image files and break easily when files move.

Print, PDF or email?

• Print: Finish & Merge > Print Documents. Each letter starts on a new page. Print a short range first (From 1 To 3) to check the paper, the address position and double-sided settings.
• PDF: Finish & Merge > Edit Individual Documents creates one document with all letters; File > Save As > PDF turns it into one combined PDF. Word cannot save each customer's letter as its own PDF without a macro or an add-in.
• Email: Finish & Merge > Send Email Messages sends the letter text as the email body through Outlook, using an email column from your list. It cannot attach each customer's letter as a PDF.

If the letters should reach customers by email as proper documents, the PDF route is what most businesses want, and that is where Word stops being convenient.

Before you send: a short checklist

• Preview a row with every field filled, a row with gaps (no title, no company), and the row with the longest company name.
• Check amounts and dates for the right format.
• Use Check for Errors on the Mailings tab before a large print run.
• Print or open three letters and read them as the recipient would.

For the very first mail merge, with a smaller example and every click spelled out, see the simple mail merge walkthrough.

When an online tool is easier

Word is a good choice when you print a batch of letters from your own computer. An online tool is easier when you need one PDF per customer, want to email each letter as an attachment, or do not have Word installed. MailMergic works with the same Word templates in the browser:

• Upload your letter (.docx) and your Excel, CSV or Google Sheets list, then drag the columns into the letter.
• Show or hide paragraphs with visual rules instead of IF field syntax, for example a reminder only for customers with an open balance, or a different signature block per region. Empty address lines are hidden automatically.
• Date, currency and number formats from your spreadsheet are kept, and you can place a different image per row, such as the signing manager's signature.
• Generate one PDF or Word file per customer, named from your data (for example Letter_10482_Becker.pdf), optionally with a password per file.
• On the paid plans, email each letter to its recipient as a PDF attachment, with merge fields in the subject line and message.

Templates can be saved and reused for the next run. The free plan covers 100 documents a month (with a watermark), no credit card required. Start a business letter mail merge in MailMergic or read more about Word mail merge with MailMergic.