Using Mail Merge with Office 365 Word

Dear @Michael Shannon,

Welcome to Microsoft Q&A Forum!

Thanks for the detailed explanation and this may be a common point of confusion when using Mail Merge with Word for Microsoft 365 on macOS. Let me break down what’s happening and how you can get your Excel list recognized properly:

1.Most online tutorials show the Windows version of Word, which includes the step‑by‑step Mail Merge Wizard. On macOS, the wizard does not exist, so it’s normal that you can’t find it. You’ll instead use the Mailings tab directly: Mailings > Select Recipients > Use an Existing List

This is the Mail Merge flow on Mac.

2.Word isn’t recognizing your Excel fields:

This typically happens when the Excel sheet isn’t formatted in a way that Word can read as a data source. Therefore, I have several suggestions that you may check:

(A): Make sure your Excel sheet is clean and structured:

Word requires:

• All data on one sheet.
• Row 1 must contain clear header names (no merged cells, no blanks).
• No mixed data types in a column (e.g., numbers + text).

Issues like Word showing fields as “F1, F2 …” or not showing your headers at all happen when the first row isn’t recognized as header information.

(B): Confirm that Word is using your first row as headers:

• When you choose your Excel file, Word may prompt you with a dialog asking whether the first row contains column names.
• If it doesn’t, it will treat everything as generic fields, just like the behavior you’re seeing.

(C): Ensure your data is on the first worksheet:

• Some Word merge features only read Sheet1.
• If your list is on Sheet2 or deeper, move that sheet to the front.

3.Recommended ideas for you:

-Open your Excel file:

• Make sure all data is on a single sheet
• Confirm that Row 1 contains plain text headers
• Save as .xlsx

-Move that sheet to the first position in the workbook.

-In Word (Mac): Mailings > Select Recipients > Use an Existing List > choose the Excel file

-When prompted, check the option that says: “First row of data contains column headers”.

After these steps, the merge fields should appear correctly so you may insert them into your envelope layout.

I hope this information can help you in this case and you can also check Mr. Bob Jones's article to see if it can help you. Wish you a pleasant day!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

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.

For comprehensive instructions on Mail Merge to Envelopes in current versions of Mac Word see this Microsoft article.or go to Help> Word Help in the Word menu bar & use the search term mail merge with envelopes.

I believe you've been looking at old information or instructions which pertain to Mail Merge in Word for Windows. The Mail Merge feature in Word for Windows is quite different in several ways.