How to Mail Merge from Excel to Word, Email and Labels

To mail merge from Excel, connect the workbook to Word. Word then reads the sheet row by row and turns each row into a letter, a label or an email with that person's details.

A cricket club in Norwich keeps 900 past and present members on one Excel sheet, 320 of them current. Every March, the club secretary posts renewal letters to the 70 current members who want paper and emails the others. Both jobs start from the same workbook, and most of the work is getting that sheet right.

How to set up an Excel sheet for a mail merge

Word treats the sheet as a table. Row 1 names the columns, and every row below it is one member. These are the first rows of the club's sheet; the full version also has Address, Town and Status columns, with Status set to Current or Lapsed.

First name	Last name	Email	Postcode	Phone	Renews	Fee	Post
Olivia	Hughes	[email protected]	NR2 4AB	07700900461	01/04/2027	£85.00	No
James	Carter		NR4 7TJ	07700900218	01/04/2027	£45.50	Yes
Amelia	Price	[email protected]	NR3 1HG	07700900735	01/05/2027	£85.00	No

Five rules decide whether Word reads it cleanly. Most of them come from Microsoft's tips for an Excel data source (October 2026).

Rule	Why Word needs it
Column names in row 1, with nothing above them	Word reads the first row as the field names. A title such as "Members 2027" in row 1 would take their place
One detail per column	A greeting can then use the first name on its own
The whole list on the first sheet	Word reads one sheet as the list, so rows on other sheets are left out of the merge
Edits finished before you connect the file	Word takes the column list when it connects, so a column added later may not appear until you reconnect
No blank rows, totals or notes under the list	Word merges every row below the headers as if it were a member

In the Email column, keep one address per cell and nothing else in it, such as a note or a second address. Phone numbers, dates and prices need one more step each, set out in the fixes further down.

Mail merge from Excel to Word: letters

Letters are the classic use: Word makes one page per row, ready to print or save. The renewal letter goes only to current members whose Post column says Yes.

1. Open the letter in Word and go to Mailings > Start Mail Merge > Letters.
2. Choose Select Recipients > Use an Existing List, open the workbook and pick the sheet that holds the list.
3. Click Edit Recipient List, then Filter. Set Field to Post, Comparison to Equal to and Compare to to Yes, then add a second row with And for Status Equal to Current.
4. Put the cursor where the address goes and click Address Block. Add Greeting Line for "Dear James," and use Insert Merge Field for the fee and the renewal date.
5. Click Preview Results and step through a few members with the arrows.
6. Choose Finish & Merge > Edit Individual Documents for one file with every letter, or Print Documents to print straight away.

If Address Block or Greeting Line shows a blank or wrong name in the preview, click Match Fields in that dialog. There you tell Word which column holds each part, such as Forename for First Name.

The Greeting Line dialog also sets the text for rows without a usable name, such as "Dear Sir or Madam," (Microsoft Support). A plain First name field has no such fallback, so a missing name leaves "Dear ," on the page.

Mail merge labels from Excel

Labels use the same sheet and the same filter. Word lays the addresses out on a grid that matches your label sheet.

1. In a blank document, choose Labels under Mailings > Start Mail Merge.
2. In Label Options, choose the label supplier and the product number printed on the pack.
3. Connect the workbook, then apply the letter filter.
4. In the first label, click Address Block and format it the way every label should look.
5. Click Update Labels to copy that layout to every label on the page.
6. Click Preview Results, then Finish & Merge > Print Documents.

Is the number on your pack missing from the list? Choose New Label in Label Options and enter the label's measurements instead (Microsoft Support).

Mail merge from Excel to email with Outlook

The renewal email uses that workbook too. Only one step depends on the sheet itself: leaving out the members who have no address.

1. Choose E-mail Messages under Start Mail Merge and connect the workbook as for the letters.
2. In Edit Recipient List, filter Status to Current, Post to No and Email to Is not blank. Microsoft asks for an address for every recipient (Microsoft Support), so the last condition drops anyone whose Email cell is empty.
3. Write the email in the document, with Greeting Line and merge fields where they belong.
4. Choose Finish & Merge > Send E-mail Messages, pick the Email column in To, type the subject and confirm.

On Windows, the send needs classic Outlook. If your computer has moved to new Outlook, mail merge in Outlook explains the way back.

Why isn't Word mail merge working with Excel?

When Word cannot open the list at all, the file's location is the usual cause. Microsoft does not support a mail merge data source saved at a web (HTTP) address, which rules out a workbook opened through a browser link. Save a copy on the computer or a file share instead (Microsoft Support).

If the merge field buttons are greyed out, the document has no list attached. Choose Select Recipients again.

When Word reads the list but some values look wrong, the cause is how Excel stores them. Word takes the stored value, not the format on screen, and formatting applied in Excel is not kept in the merge (Microsoft Support). Phone, Renews and Fee in the sheet above show it.

Leading zeros disappear from phone numbers

Type 07700900461 into an ordinary cell and Excel stores the number 7700900461, so the merge prints it without the zero. The fix is to format the column as Text before you type the numbers. For a CSV (comma-separated values) export, set that column's type to Text while you import the file into Excel (Microsoft Support).

Formatting a column afterwards does not bring lost zeros back. For numbers already typed, add a column that wraps each one in TEXT, Excel's formatting function, and merge that column instead. UK mobile numbers have 11 digits counting the 0, so the format has 11 zeros:

=TEXT(E2,"00000000000")

A custom number format such as 00000000000 changes only how the cell looks. The cell still holds the number Word reads, and Microsoft offers that format only for workbooks no other program uses as a data source.

Guides written for American lists warn about ZIP codes. In the UK, postcodes contain letters, so Excel keeps them as text and they merge as typed. The zeros at risk sit in phone, account and membership numbers.

Dates arrive in the wrong order

Word can show 01/04/2027 as 4/1/2027, month first, which a British reader takes as 4 January. Word fixes it with a date switch on the merge field.

1. Right-click the Renews field and choose Toggle Field Codes, or press Alt+F9 to show every field code.
2. Type the switch before the closing bracket, as below.
3. Right-click it, choose Update Field, then Alt+F9 again to hide the codes and preview.

In the switch, d is the day, MMMM (four capital Ms) is the full month name and yyyy is the year. Months take a capital M, because a lowercase m means minutes (Microsoft Support).

{ MERGEFIELD Renews \@ "d MMMM yyyy" }

The letter now says 1 April 2027. For 01/04/2027 instead, use "dd/MM/yyyy" as the switch.

Prices lose the £ sign

Excel's currency format is display only too, so £85.00 can arrive as 85 and £45.50 as 45.5. Typing £ before the field brings the sign back but still prints £45.5. A number switch fixes both:

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

With the switch, the fees print as £85.00 and £45.50.

Can you mail merge from Excel to Excel?

No: Excel has no merge command of its own, and Microsoft's steps for mailing labels from an Excel list hand the job to Word.

Inside Excel, a formula can build one personal line per row instead. For the sheet above, it looks like this:

="Dear "&A2&", your renewal of £"&TEXT(G2,"0.00")&" is due on "&TEXT(F2,"d mmmm yyyy")&"."

Excel's format codes ignore case, so the lowercase mmmm that Word would read as minutes gives the month here. Fill the formula down the sheet and Olivia's row reads "Dear Olivia, your renewal of £85.00 is due on 1 April 2027." The result is text in a cell. It helps you check the data or paste a line into a message, but it sends and prints nothing.

Sending marketing email to an Excel list

The summer coaching camp email is a different job: it sells places to 900 current and lapsed members, so it is marketing. UK rules expect a working opt-out in every marketing email, one of the points where mail merge stops working. The club will also want to see who clicked through to the booking page.

A Word merge gives the secretary neither, so this send belongs in an email platform. The sheet already cleaned up for Word is the easiest way in.

Getting the Excel list into MailGraf

MailGraf's file import reads the workbook itself. Imports > New import accepts CSV, Excel (.xlsx) and text (.txt) files, so the sheet goes in without conversion. The import screens and the result report then show what happened to each row.

Where in the import	What it tells you about the sheet
First row is a header, on the Mapping step	Keep it ticked when row 1 holds the column names
Preview, on the same step	The first rows as MailGraf will save them, before anything is imported
Repaired addresses	Cells MailGraf could fix, such as mailto:[email protected], saved as the plain address
Repeated in file	The same address in two rows, such as a couple sharing one email; the contact is added once
Invalid rows	Each skipped row with its row number and reason. Download report saves the list for fixing in Excel
Update contacts that already exist	Next year's sheet updates members already imported, and empty cells leave saved details alone

Mapping the Status column to a custom field lets you segment the list by Current and Lapsed. The camp email can then reach lapsed members with a "come back" line and current members without one.

If more emails like it will follow, make the club's .xlsx file the first import in a new MailGraf account.