how to do mailmerge

Question

Hello! I am trying to do mailmerge for mac. I have tried every which way, i.e. saving list to desktop, saving data source file as .xlx, .csv, and have not been susccessful. MS Word says it's unable to access the data source.

Answer 1

Please see this Mail Merge article & the links within it.

Reply here if you have any specific questions. Be sure t include the current Version Number of your Office software along with a clear explanation of the problem.

Answer 2

Hi @Rani Zarnegar,

The error message can show up due to one of these reasons: the file format, the sheet structure, the file location, or Word not being able to open the workbook. Based on your sharing, the issue is from the Excel sheet structure that you are currently using .csv and .xlx for Word mail merge since it is suggested to use normal Excel workbook (.xlsx) to mail merge in Word for Mac.

I suggest you can try following these steps to do a mail merge in Word:

• Create an Excel file with first row as field names (e.g. Names, Emails) and insert the recipient's information below. After that, save it in your Mac Documents as a normal Excel workbook (.xlsx)

• Then open Word and go to Mailings tab > Select Recipients > Use an existing list > select that Excel file and Open. When prompted, choose Yes/OK

• Now you can start mail merge. Write your letter and for example, whenever mentioning the recipient's name, select Insert Merge Field and add Names field there.

• You can select Preview Results to double check your mail merge contents. After finishing, select Finish & Merge > sent to email

I hope this information will help. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.

Thank you for your understanding and cooperation. I look forward to hearing from you. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Answer 3

On macOS Word, mail merge works reliably only with supported data sources and when they are formatted and connected correctly. Use these steps end-to-end and verify each point, as “unable to access the data source” usually means either the file type, sheet/range, or location is not acceptable to Word.

1. Prepare the Excel data source
2. Put all data on a single worksheet (no merged cells, no blank header row).
3. Row 1 must contain field names (e.g., FirstName, LastName, Address1, City, State, Zip) with no completely empty header cells.
4. Save the file as a normal Excel workbook (.xlsx) in a local folder (e.g., Documents). Avoid network shares, synced cloud folders, or external drives while testing.
5. Close Excel so Word can open the file.

Excel is a supported data source on Mac if all data is on one sheet and formatted so Word can read it. For more details, see “Excel spreadsheet works well as a data source if all data is on one sheet and the data is formatted so that it can be read by Word.”

2. Start the mail merge in Word for Mac
3. Open a new or existing Word document.
4. Go to Mailings > Start Mail Merge and choose the document type (e.g., Letters, Envelopes, Labels, or E-mail Messages).
5. Connect to the Excel list correctly
6. In Word, go to Mailings > Select Recipients > Use an Existing List.
7. Browse to the .xlsx file in the local folder and choose Open.
8. In the Open Workbook dialog:
   • Select the worksheet that contains the data.
   • Leave Cell Range blank to use the entire sheet, or specify a valid range (e.g., A1:F3000).
9. Choose OK.

If Word previously failed when the file was on the Desktop or saved as .csv, test with a simple .xlsx in Documents using the steps above. Word for Mac supports Excel, text, and other sources, but the Excel path above is the most reliable.

4. Check and edit the recipient list
5. Go to Mailings > Edit Recipient List.
6. Confirm that the records appear. If they do not, the issue is with the file, sheet, or range selection.
7. Optionally sort or filter using the dialog (see “Mail merge: Edit recipients,” “Sort the data for a mail merge,” and “Filter the data for a mail merge” for details).
8. Select OK.
9. Insert merge fields
10. Place the cursor where the personalized data should appear.
11. Go to Mailings > Insert Merge Field.
12. Choose the fields (e.g., FirstName, LastName, Address1, etc.).
13. Repeat for all needed fields.
14. Save the document (File > Save).
15. Preview and finish the merge
16. Go to Mailings > Preview Results.
17. Use Next / Previous to step through records and confirm the data appears correctly.
18. Go to Finish & Merge and choose Print Documents or Merge to E-mail as needed.
19. If “unable to access data source” persists

Based on supported data sources on macOS:

• Ensure the file is one of the supported types (Excel workbook, text file with comma/tab delimiters, or a Word data file). Avoid older formats like .xls or problematic .csv encodings while troubleshooting.
• Move the file to a simple local path (e.g., ~/Documents/MergeData.xlsx) and reconnect via Use an Existing List.
• Confirm the sheet has a proper header row and no unusual characters in field names.
• As an alternative, create a new list directly in Word:
  • In Select Recipients, choose Create a New List and use the dialogs to build and save a Word data file, then test the merge. This verifies that the mail merge engine itself is working.

If the Word-created list works but Excel does not, the problem is with the Excel file’s structure (multiple sheets, missing header row, or formatting) or its location.

---

References:

• Use mail merge for bulk email, letters, labels, and envelopes
• Mail merge using an Excel spreadsheet
• Data sources you can use for a mail merge