Mail Merge Still Works: Here’s How to Use It Properly

Mail merge may sound like an old Microsoft Word feature, but it remains one of the fastest ways to create personalised letters, labels, envelopes and email messages from a structured contact list.

Instead of copying the same document repeatedly and changing each customer’s name, address or account details by hand, mail merge combines one master document with a data source such as an Excel spreadsheet. Word then creates a personalised version for every selected recipient.

It is particularly useful for businesses, schools, charities, clubs and anyone who regularly sends similar communications to several people.

This guide explains how mail merge works, how to prepare an Excel list, how to insert personalised fields and how to avoid the formatting problems that cause most failed merges.

What Is Mail Merge?

Mail merge combines two main components:

1. A main document containing the wording and design
2. A data source containing the information that changes for each recipient

The main document might contain a sentence such as:

Dear «First_Name»,

The data source contains the actual names:

During the merge, Word replaces the field with the relevant value for each record:

Dear Amy,
Dear Ben,
Dear Chloe,

The wording, logo, layout and formatting remain consistent while the personal information changes.

Microsoft Word currently supports mail merge for personalised letters, email, envelopes, labels and directory-style documents. Common data sources include Excel spreadsheets, Outlook contacts and lists created directly in Word. 

What Can You Create With Mail Merge?

Mail merge is useful for much more than traditional posted letters.

You can create:

• Customer letters
• Appointment reminders
• Renewal notices
• Certificates
• Invoices or statements
• Address labels
• Envelopes
• Event invitations
• Membership communications
• Staff notices
• Email campaigns
• Product or asset labels
• Directories
• Personalised offers

The best use cases involve documents that share the same basic design but require different information for each recipient.

A Simple Real-World Example

Imagine a business needs to send contract-renewal reminders to 200 customers.

Each letter should contain:

• Customer name
• Company
• Postal address
• Contract number
• Renewal date
• Account manager

Without mail merge, someone might duplicate the document 200 times and edit every letter manually.

With mail merge, the business creates one Word letter and one Excel list.

The Word document could contain:

Dear «First_Name»,

Your «Service_Name» agreement, reference «Contract_Number»,

is due for renewal on «Renewal_Date».

Your account manager is «Account_Manager».

Word generates a personalised letter for each row in Excel.

The Three Main Stages

A successful mail merge has three basic stages:

Prepare the Data

Create a clean list with one row per recipient and one column per field.

Build the Document

Write the letter, email, label or envelope and insert merge fields where personal information should appear.

Preview and Complete the Merge

Check the results, choose the recipients and then print, edit or send the finished documents.

Most mail merge problems begin in the first stage, so preparing the data properly is essential.

Step 1: Prepare the Excel Mailing List

Excel is one of the most common mail merge data sources because it is easy to edit, filter and validate.

Microsoft recommends keeping the data on one well-formatted worksheet, using column headings that correspond with the fields you want to insert. Changes should ideally be completed before connecting the workbook to Word. 

Use One Row Per Recipient

Each row should represent one person, business or record.

For example:

Do not place several recipients in one row.

Use One Column Per Type of Information

Keep information in separate fields.

Use:

• First_Name
• Surname
• Address_1
• Address_2
• Town
• County
• Postcode

Avoid placing the complete address into one cell unless you are certain it will always be used as one block.

Separate fields give you more control over layout, filtering and personalisation.

Add Clear Column Headings

Word uses the first row of the spreadsheet as the list of available merge fields.

Good headings include:

• First_Name
• Surname
• Company
• Email
• Renewal_Date
• Contract_Number
• Account_Manager

Avoid unclear headings such as:

• Info
• Value
• Details
• Column1
• Other

Using underscores instead of spaces can make field names easier to recognise inside Word.

Keep All Merge Data on One Worksheet

Place the mailing list on one worksheet whenever possible.

Avoid:

• Separate worksheets for each region
• Decorative titles above the headings
• Blank rows before the data
• Multiple unrelated tables on the same sheet
• Totals below the mailing list

A clean mailing-list worksheet should begin with the headings in row 1 and the recipient records immediately beneath them.

Convert the List Into an Excel Table

Although not essential, converting the range into an Excel Table helps keep the list organised.

Click inside the data and press:

Ctrl + T

Confirm that My table has headers is selected.

Benefits include:

• Automatic filters
• Easier sorting
• Consistent formatting
• Simpler expansion when records are added
• Better visibility of blank or duplicated entries

Give the table a meaningful name such as:

RenewalRecipients

Remove Blank Rows

Blank rows may interrupt the detected data range or create empty merge records.

Delete completely empty rows from the mailing list.

A blank optional field such as Address_2 is acceptable. An entirely blank recipient row is not.

Remove Merged Cells

Merged cells cause problems in data sources.

Each piece of information should occupy its own normal cell.

Keep titles, branding and visual formatting outside the data table.

Check for Duplicate Recipients

Duplicate rows can result in someone receiving the same letter or email twice.

In Excel:

1. Select the mailing list.
2. Open Data.
3. Choose Remove Duplicates.
4. Select the fields that identify a unique recipient.
5. Review the result carefully.

For email campaigns, the Email field may be the best duplicate check.

For postal letters, use a combination such as:

• First name
• Surname
• Address
• Postcode

Do not remove duplicates automatically when two people at the same address should each receive a communication.

Clean Extra Spaces

Invisible spaces can cause incorrect names, failed filters and awkward gaps.

Use:

=TRIM(A2)

For text copied from websites or other systems:

=TRIM(CLEAN(A2))

After checking the results, paste the cleaned values back into the source column where appropriate.

Check Capitalisation

Avoid lists containing:

• AMY JONES
• amy jones
• Amy jones

You can use:

=PROPER(A2)

However, review names manually because Proper Case can mishandle names and brands such as:

• McDonald
• O’Neill
• iPhone
• eBay

Store Postcodes as Text

Postcodes and other identifiers should usually be stored as text.

This helps preserve:

• Leading zeros
• Letters
• Spaces
• Exact formatting

The same applies to:

• Membership numbers
• Customer references
• Telephone numbers
• Product codes
• Employee IDs

Store Dates as Genuine Dates

Dates should be genuine Excel dates rather than text that merely looks like a date.

You can test a date using:

=ISNUMBER(A2)

A valid Excel date normally returns TRUE.

Use a consistent display format such as:

02 August 2026

Be cautious with ambiguous formats such as:

03/08/2026

In a UK workbook this usually means 3 August, but other systems may interpret it differently.

Check Currency and Percentage Fields

Currency and percentages should be stored as numbers and formatted through Excel.

Do not type values such as:

£1,250 approximately

into a field that needs to merge as a number.

Store:

1250

and use an appropriate number format.

Word may not always reproduce Excel’s visible number formatting exactly, so important currency and date fields must be checked during preview.

Close and Save the Excel File

Save the workbook before connecting it to Word.

For the simplest workflow:

• Keep the Excel file in a stable local or approved business folder.
• Avoid renaming or moving it during the project.
• Complete major edits before connecting the list.
• Close Excel if Word has difficulty opening the data source.

Microsoft’s guidance recommends completing changes or additions before connecting the spreadsheet to the Word merge document. 

Step 2: Create the Main Word Document

Open Microsoft Word and create the document that every recipient will receive.

This can include:

• Company logo
• Header and footer
• Contact details
• Standard wording
• Signatures
• Terms and conditions
• Page numbers
• Branding

Leave space for the personalised merge fields.

Start the Mail Merge

In Word:

1. Open the Mailings tab.
2. Select Start Mail Merge.
3. Choose the appropriate document type.

Common choices include:

• Letters
• Email Messages
• Envelopes
• Labels
• Directory

For a normal personalised letter, choose Letters. Microsoft’s documented process begins through Mailings > Start Mail Merge > Letters. 

Use the Step-by-Step Wizard

Word also includes a guided Mail Merge Wizard.

Open:

Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard

This displays a panel that walks through:

1. Document type
2. Starting document
3. Recipients
4. Writing the document
5. Preview
6. Completion

The wizard is useful for beginners, especially when creating labels or envelopes.

Step 3: Connect the Mailing List

In Word:

1. Open Mailings.
2. Select Select Recipients.
3. Choose Use an Existing List.
4. Browse to the Excel workbook.
5. Select the correct worksheet or named table.
6. Confirm that the first row contains headings.

Word now connects the document to the spreadsheet.

Microsoft also allows you to select Outlook contacts or create a new list directly in Word when no existing data source is available. 

Choose the Correct Worksheet

When Word opens the Excel file, you may see several options such as:

Sheet1$

RenewalRecipients

Choose the worksheet or table containing the mailing list.

A named Excel Table is easier to recognise than a generic sheet name.

Edit the Recipient List

Select:

Mailings > Edit Recipient List

This allows you to:

• Include or exclude recipients
• Sort records
• Filter records
• Search for entries
• Remove duplicate results
• Select only certain groups

For example, you could filter for:

• Region equals North
• Renewal date before a specific date
• Status equals Active
• Balance greater than £500

Word supports sorting and filtering the connected list before the merge is completed. 

Step 4: Insert Merge Fields

Merge fields are placeholders linked to the column headings in Excel.

Place the cursor where personalised information should appear, then select:

Mailings > Insert Merge Field

Choose the required field.

Microsoft confirms that available merge fields are created from the column headings in the connected data source. 

Insert an Address Block

For postal letters, place the cursor where the address should appear and choose:

Mailings > Address Block

Word attempts to construct the address from recognised fields.

Preview it carefully.

The Address Block may not always arrange UK addresses exactly as required, particularly when fields are incomplete.

You can instead insert individual fields manually:

«Title» «First_Name» «Surname»

«Company»

«Address_1»

«Address_2»

«Town»

«County»

«Postcode»

Manual fields provide greater control.

Insert a Greeting Line

Choose:

Mailings > Greeting Line

You can select a style such as:

Dear Mr Jones,

or:

Dear Amy,

You can also specify what Word should use when a recipient’s name is missing.

Microsoft provides Address Block for addresses and Greeting Line for personalised letters and email messages. 

Build a Greeting Manually

A manual greeting often gives more predictable results:

Dear «First_Name»,

Or:

Dear «Title» «Surname»,

Make sure the Excel list contains the information needed for the chosen format.

Insert Other Fields

You can add fields anywhere in the document.

For example:

Account reference: «Account_Number»

Renewal date: «Renewal_Date»

Current package: «Service_Name»

Account manager: «Account_Manager»

Merge fields can also be placed inside:

• Tables
• Headers
• Footers
• Text boxes
• Labels
• Certificates

Test these areas carefully because some complex layouts can behave unpredictably.

Step 5: Preview the Results

Never complete a mail merge without previewing it.

Select:

Mailings > Preview Results

Word replaces the field names with actual information from the first recipient.

Use the arrow controls to move through several records.

Check:

• Long names
• Blank company fields
• Missing address lines
• Unusually long addresses
• Date formats
• Currency formats
• Page breaks
• Greeting lines
• Punctuation
• Spacing
• Email addresses
• Records containing accents or apostrophes

Do not check only the first recipient.

The first record may be perfect while later records reveal layout problems.

Look for Blank Lines

Suppose Address_2 is empty.

A manually inserted address might create:

12 Market Road

Harrogate

HG1 1AA

Whether this matters depends on your layout.

You may be able to use Word’s Address Block, conditional rules or carefully designed paragraphs to suppress unwanted blank lines.

Check Long Company Names

A long company name may wrap onto another line and push the rest of the letter downward.

Test records containing:

• The longest company name
• The longest address
• Double-barrelled surnames
• Long account references
• Missing fields

Check Page Counts

A letter designed for one page may become two pages for recipients with longer details.

Use:

Finish & Merge > Edit Individual Documents

to create a complete merged document for final inspection before printing.

Step 6: Finish the Mail Merge

Select:

Mailings > Finish & Merge

You will normally see options including:

• Edit Individual Documents
• Print Documents
• Send Email Messages

Edit Individual Documents

This creates a new Word document containing all merged records.

Use this when you need to:

• Review every letter
• Make recipient-specific changes
• Save a copy of the final batch
• Print after a detailed inspection
• Remove a particular document

This is generally the safest choice for important postal communications.

Print Documents

This sends the merged output to the printer.

Before printing hundreds of pages:

1. Print one test record.
2. Check paper orientation.
3. Check margins.
4. Check letterhead alignment.
5. Confirm duplex settings.
6. Verify the printer tray.
7. Check envelope or label stock.
8. Print a small batch.

Send Email Messages

For email merges:

1. Select Finish & Merge.
2. Choose Send Email Messages.
3. Select the column containing email addresses.
4. Enter the subject line.
5. Choose the message format.
6. Select the records.
7. Confirm the send.

Word sends each message individually using the connected mail application and account configuration. Each recipient appears alone on the To line rather than seeing the complete mailing list. 

Using Mail Merge for Email

Mail merge can be useful for straightforward personalised email, but it is not a complete email-marketing platform.

Good uses include:

• Appointment reminders
• Customer notices
• Renewal prompts
• Internal communications
• Training invitations
• Small membership updates
• Account-specific information

What Email Mail Merge Does Well

It can personalise:

• Recipient name
• Company
• Account number
• Renewal date
• Assigned adviser
• Other list-based information

It also sends separate messages rather than exposing everyone’s address through CC.

Limitations of Email Mail Merge

Word email mail merge is less suitable when you need:

• Sophisticated templates
• Automated unsubscribe management
• Campaign analytics
• Open tracking
• Click tracking
• Bounce management
• Complex attachments
• Scheduled journeys
• Behaviour-based automation
• Consent management at scale

For marketing campaigns, use a suitable email-marketing platform and follow applicable privacy and direct-marketing requirements.

Can Mail Merge Add Attachments?

Standard Word email mail merge does not provide a simple built-in option for attaching a different file to each recipient.

Possible alternatives include:

• Linking to files securely
• Using a specialist mail-merge add-in
• Using Power Automate
• Creating Outlook drafts through an approved workflow
• Sending personalised documents through a secure portal

Be cautious with add-ins that request access to email and contact data.

Using Mail Merge for Labels

Mail merge is effective for address and product labels.

In Word:

1. Open Mailings.
2. Choose Start Mail Merge > Labels.
3. Select the label manufacturer.
4. Select the product number printed on the packaging.
5. Connect the recipient list.
6. Design the first label.
7. Choose Update Labels.
8. Preview the results.
9. Print a test on plain paper.
10. Compare it against the label sheet.

Microsoft’s label workflow uses the selected label vendor and product number to create the correct layout. 

Always Test Label Alignment

Before loading expensive labels:

1. Print the merged page on ordinary paper.
2. Hold it behind the label sheet.
3. Check the alignment against a light source.
4. Adjust margins if necessary.
5. Confirm printer scaling is set to 100%.

Do not select:

• Fit to Page
• Shrink to Fit
• Scale to Paper Size

These settings can shift the labels.

Why Only the First Label Changes

When designing labels, Word initially works with the first label.

After inserting the required fields, select:

Mailings > Update Labels

This copies the layout to the remaining labels and adds the necessary Next Record instructions.

Using Mail Merge for Envelopes

For envelopes:

1. Choose Start Mail Merge > Envelopes.
2. Select the envelope size.
3. Configure the feed method.
4. Insert the delivery address.
5. Add a return address if required.
6. Connect the mailing list.
7. Preview several records.
8. Test one envelope.

Microsoft’s documented envelope process includes setting up the list, testing the layout, starting the merge, linking the data and completing the merge. 

Printer envelope feeds vary considerably, so test the direction and orientation before running a complete batch.

Mail Merge Rules

Word includes rules that can change the document according to the recipient’s data.

Open:

Mailings > Rules

Available options may include:

• If…Then…Else
• Ask
• Fill-in
• Next Record
• Next Record If
• Skip Record If
• Set Bookmark

If…Then…Else

This allows different wording based on a field.

For example:

• If Region equals North, use the Harrogate office number.
• Otherwise, use the general contact number.

Another example:

• If Balance is greater than zero, include a payment reminder.
• Otherwise, include a thank-you message.

Skip Record If

This prevents certain records from being included.

For example:

• Skip if Status equals Cancelled.
• Skip if Email is blank.
• Skip if Do_Not_Contact equals Yes.

Filtering the recipient list is usually easier, but a rule can be useful for document-specific logic.

Next Record

The Next Record field is used when several records must appear on the same page, such as:

• Labels
• Directories
• Lists
• Name cards

Microsoft documents Next Record and Next Record If as rules that move the merge to the following data record. 

How to Format Dates Properly

One of the most common mail merge problems is a date appearing as:

08/02/2026 00:00:00

instead of:

2 August 2026

The Excel format may not always carry into Word as expected.

You can apply a formatting switch to the merge field.

Display the Field Code

Right-click the field and choose:

Toggle Field Codes

Or press:

Alt + F9

You may see:

{ MERGEFIELD Renewal_Date }

Change it to:

{ MERGEFIELD Renewal_Date \@ "d MMMM yyyy" }

This produces:

2 August 2026

Other examples include:

{ MERGEFIELD Renewal_Date \@ "dd/MM/yyyy" }

and:

{ MERGEFIELD Renewal_Date \@ "MMMM yyyy" }

Press Alt + F9 again, then update or preview the field.

How to Format Currency

A currency value may merge as:

1250

or:

1250.000000

Use a numeric picture switch:

{ MERGEFIELD Amount \# "£#,##0.00" }

This produces:

£1,250.00

For whole pounds:

{ MERGEFIELD Amount \# "£#,##0" }

Always preview negative, zero and large values.

How to Format Percentages

If Excel stores 25% as 0.25, Word may merge the underlying value.

A field switch can help, although percentage formatting can be awkward because Word field calculations differ from Excel.

For important reports, consider creating a separate text field in Excel:

=TEXT(A2,"0%")

Name the column:

Formatted_Percentage

Then merge that prepared display value.

Why Numbers and Dates Sometimes Merge Incorrectly

Word and Excel may communicate through a data connection that reads the underlying values rather than exactly reproducing the visible Excel format.

Microsoft documents cases where date, telephone and currency fields can merge differently when using Excel or Access data sources. 

Reliable solutions include:

• Using Word field switches
• Creating formatted helper columns in Excel
• Confirming the Excel data type
• Testing the merge before completion
• Avoiding mixed data types in one column

Handling Missing Names

A greeting such as:

Dear «First_Name»,

may become:

Dear ,

when the first name is blank.

Possible solutions include:

• Fixing the source data
• Filtering out incomplete records
• Using a Greeting Line with fallback text
• Using an If…Then…Else rule
• Creating a prepared greeting column in Excel

An Excel formula could create a complete greeting:

=IF(A2="","Dear Customer,","Dear "&A2&",")

Then merge the Greeting field as one complete line.

This is often easier than complex Word field logic.

Creating a Prepared Name Field

Names do not always fit one format.

A business contact may need:

Ms Amy Jones

while another record may contain only a company.

Create a helper column in Excel:

=IF(D2<>"",D2,TRIM(A2&" "&B2&" "&C2))

This might use the company where present and the personal name otherwise.

Name the column:

Display_Name

Preparing complex display logic in Excel often makes the Word document easier to maintain.

Protecting Personal Data During Mail Merge

Mail merge frequently involves personal information such as:

• Names
• Addresses
• Email addresses
• Account references
• Contract dates
• Financial details
• Membership information

Handle the files carefully.

Restrict Access

Store the Excel and Word files in an approved location accessible only to authorised users.

Avoid placing customer lists in:

• Personal cloud accounts
• Unencrypted USB drives
• Public shared folders
• Personal email
• Unapproved file-transfer services

Check the Recipient Filter

Before completing the merge, confirm that the correct people are selected.

This is particularly important when a spreadsheet contains:

• Former customers
• Suppression records
• People who opted out
• Test data
• Internal recipients
• Cancelled accounts

Avoid Exposing Other Recipients

For email mail merge, confirm that each message is being sent individually.

Do not replace mail merge with a normal message containing the complete mailing list in the To or CC fields.

Protect Finished Documents

A merged Word document may contain hundreds of customer records.

Do not keep it longer than necessary.

Store, archive or delete it according to the organisation’s retention requirements.

Send Sensitive Documents Securely

Mail merge can personalise a document, but ordinary email may not be suitable for confidential information.

For sensitive data, consider:

• Password-protected documents
• Secure file portals
• Customer portals
• Encrypted email systems
• Individual access links

Do not send passwords in the same email as encrypted files.

Common Mail Merge Problems

The Wrong Excel Worksheet Appears

Make sure the correct data is on a clearly named worksheet or Excel Table.

Remove obsolete sheets or name the intended source clearly.

Word Cannot Open the Excel File

Try:

• Saving and closing Excel
• Moving the workbook to a local folder
• Checking file permissions
• Removing unsupported protection
• Confirming the workbook is not corrupted
• Saving a clean copy as .xlsx

Some Recipients Are Missing

Check:

• Recipient filters
• Unticked records
• Blank rows
• Hidden source rows
• The selected worksheet
• Whether the data range includes every row

New Excel Rows Do Not Appear

The connected list may not have refreshed or may use a limited range.

Try:

• Saving the spreadsheet
• Reopening the Word document
• Selecting the data source again
• Using an Excel Table
• Checking Edit Recipient List

Fields Show Their Names Instead of Values

You may be seeing:

«First_Name»

because Preview Results is turned off.

Select:

Mailings > Preview Results

If you see field codes such as:

{ MERGEFIELD First_Name }

press:

Alt + F9

The Same Recipient Appears on Every Label

The Next Record field may be missing.

Use:

Mailings > Update Labels

after designing the first label.

Blank Rows Appear in Addresses

Use:

• Address Block
• Carefully separated address paragraphs
• Conditional rules
• Clean source data
• Prepared address fields in Excel

Dates Appear as Numbers

Apply a date field switch such as:

{ MERGEFIELD Renewal_Date \@ "d MMMM yyyy" }

Currency Loses Its Pound Sign

Use:

{ MERGEFIELD Amount \# "£#,##0.00" }

Leading Zeros Disappear

Store the source value as text.

This matters for:

• Telephone numbers
• Reference numbers
• Membership IDs
• Certain international postal codes

Emails Are Not Being Sent

Check:

• The email column contains valid addresses.
• The correct email field is selected.
• Outlook or the required mail application is configured.
• The sending account is connected.
• Offline mode is disabled.
• Security software is not blocking the process.
• A test message can be sent normally.
• The organisation’s sending limits have not been reached.

The Wrong Email Account Is Used

Mail merge may send through the default or active mail profile.

Before a large send:

1. Confirm the correct account.
2. Send one test merge.
3. Check the Sent folder.
4. Confirm the sender address and signature.
5. Review any organisational sending restrictions.

Best Practices for Reliable Mail Merge

Keep the Source and Document Together

Create a project folder containing:

Renewal Mail Merge

├── Renewal Recipients.xlsx

├── Renewal Letter.docx

├── Approved PDF

└── Output

Do not move the Excel file after linking it unless you are prepared to reconnect the data source.

Use Descriptive Filenames

Avoid:

List Final New 2.xlsx

Letter Latest Updated.docx

Use:

2026 Contract Renewal Recipients.xlsx

2026 Contract Renewal Letter.docx

Create a Test Recipient

Add an internal test record containing:

• A long name
• A long address
• A valid internal email
• Representative date and currency values

Run this record first.

Test a Small Batch

Before merging 2,000 records, test:

• One recipient
• Five varied recipients
• A small internal batch

This helps identify problems before they affect the complete mailing.

Save the Main Document Before Merging

The Word document retains its connection to the data source.

Save it before selecting Finish & Merge so you can repeat the process later.

Keep Merge Fields Visible During Editing

Turn off Preview Results when changing the template so the field names remain visible.

This makes it easier to see which parts of the document are dynamic.

Use Helper Columns

When Word formatting becomes complicated, prepare the final display value in Excel.

Useful helper columns include:

• Full_Name
• Formal_Greeting
• Formatted_Date
• Formatted_Amount
• Full_Address
• Renewal_Message
• Account_Manager_Details

A clear Excel formula is often easier to troubleshoot than a complex Word field code.

Document the Process

Record:

• Which Excel file is used
• Which worksheet is selected
• Which recipients should be included
• Which filters are required
• Which fields are inserted
• How dates and money are formatted
• Who approves the output
• Where finished files are stored

This makes the process repeatable when another person needs to run it.

Mail Merge Checklist

Before connecting the data:

• Keep one untouched copy.
• Use one row per recipient.
• Use clear column headings.
• Keep the data on one sheet.
• Remove blank rows.
• Remove merged cells.
• Clean extra spaces.
• Check duplicates.
• Confirm dates are real dates.
• Store references and postcodes correctly.
• Validate email addresses.
• Save the workbook.

Before completing the merge:

• Select the correct document type.
• Connect the correct worksheet or table.
• Review the recipient list.
• Insert the required fields.
• Preview several records.
• Test the longest names and addresses.
• Check blank fields.
• Verify dates and currency.
• Check page breaks.
• Print or send a small test.
• Confirm the correct email account or printer.

After the merge:

• Review the completed documents.
• Confirm the expected record count.
• Save an approved copy where required.
• Protect personal data.
• Delete unnecessary temporary outputs.
• Record any source corrections.
• Keep the reusable template and instructions.

Is Mail Merge Still Worth Using?

Yes, when the job involves a repeated document and structured recipient data.

Mail merge remains particularly effective when:

• You already use Word and Excel.
• The layout must be consistent.
• Personalisation is straightforward.
• The batch is manageable.
• You need printed letters, envelopes or labels.
• You want a repeatable office process without new software.

A more specialised system may be better when:

• Messages must be triggered automatically.
• Each recipient needs unique attachments.
• Campaign tracking is required.
• Several approvals are involved.
• Sensitive data needs a secure portal.
• The process runs continuously.
• Data comes directly from a CRM or business platform.

Mail merge is not the newest automation technology, but it remains practical, familiar and effective.

Final Thoughts

Mail merge still works because the basic requirement has not changed: businesses regularly need to turn one standard document into many personalised versions.

The success of the merge depends less on the Mailings tab and more on the quality of the data source. Use one clean row per recipient, clear column headings and genuine dates and numbers. Then insert the fields, preview varied records and test a small batch before completing the job.

For complex formatting, create helper columns in Excel rather than forcing all the logic into Word. For sensitive information, apply proper access controls and use a secure delivery method.

Done properly, mail merge can turn hours of manual editing into a repeatable task that takes only minutes.

Need Help With Word, Excel or Microsoft 365?

Mail merge problems are often caused by poorly structured Excel lists, incorrect field formatting, missing data or Microsoft 365 configuration issues.

Hamilton Group can help organise business data, improve Word and Excel workflows, troubleshoot Microsoft 365 and create reliable repeatable processes.

Visit hgmssp.com, call 0330 043 0069, or book a meeting with one of our experts.