Office Dễ Hiểu

How to mail merge in Word from an Excel list

Create personalized letters using names, departments and meeting rooms from a spreadsheet.

Connect a Word letter to an Excel recipient list, insert merge fields and preview every record before producing the final documents.

Visual walkthrough

MailingsSelect RecipientsInsert Merge Field

Before

Dear «FullName», «Department». Meeting room: «MeetingRoom».

After

Dear Alex Morgan, Investment Team. Meeting room: Room 1.

Check the result

Preview the next record. It should show Jamie Lee and Room 2.

Try it here

Change the selection to see the result and matching data rows.

Dear «FullName», «Department». Meeting room: «MeetingRoom».
Full nameDepartmentMeeting room
Alex MorganInvestment TeamRoom 1
Jamie LeeTechnical TeamRoom 2
ResultDear Alex Morgan, Investment Team. Meeting room: Room 1.
FullNameDepartmentMeetingRoom
Alex MorganInvestment TeamRoom 1
Jamie LeeTechnical TeamRoom 2

If the CSV opens in one column, choose Data → From Text/CSV and select the comma delimiter.

Step-by-step instructions

  1. Prepare an Excel sheet with FullName, Department and MeetingRoom in its first row. Save the data, preferably as an .xlsx workbook.
  2. In Word, choose Mailings → Start Mail Merge → Letters, then Select Recipients → Use an Existing List and select the correct worksheet.
  3. Choose Insert Merge Field to place FullName, Department and MeetingRoom in the letter.
  4. Use Preview Results to check both recipients. Choose Finish & Merge → Edit Individual Documents to review the output before printing or sending.

Frequently asked questions

Can I use the downloadable CSV?

Yes. Import it into Excel, check the columns and save an .xlsx copy before connecting Word to the recipient list.

Reference: Microsoft Support