'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Word Mail Merge Showing Old Recipient Data on Mac
Question details
The user needs to fix an issue in Microsoft Word for Mac where the mail merge preview continues to show outdated recipient information despite updating the attached Excel or CSV data source.
- Product
- Microsoft Word
- Device & OS
- macOS
- Scenario
- Updating an Excel or CSV data source linked to an active Word mail merge document.
- Observed behavior
- The mail merge preview displays old recipient data instead of refreshing to show the newly updated information from the source file.
Ensure that your Excel or CSV data source file has been completely saved and closed before attempting to refresh the mail merge connection in Word.
Re-attach the Updated Data Source
Manually relinking the Excel or CSV file forces Word to drop its cached data and fetch the latest recipient list for your mail merge.
Microsoft Word on Mac often caches the linked data source for performance. If the source file was updated externally, Word might not automatically recognize the changes. Re-attaching the file refreshes the connection instantly.
Launch Microsoft Word on your Mac and open the active mail merge document that is displaying outdated information.
Navigate to the 'Mailings' tab located on the top ribbon, click on the 'Select Recipients' button, and choose 'Use an Existing List'.
Locate and select your recently saved and updated Excel or CSV data source file to link it to the document once again.
Click on 'Edit Recipient List' under the Mailings tab to confirm that the newly updated records are successfully loaded into the preview.
Use WPS Writer for Seamless Mail Merge on Mac
WPS Office provides a highly compatible and intuitive Mail Merge feature. You can effortlessly link spreadsheets to your document and generate bulk letters or labels without facing stubborn data caching issues.
- 1. Open your Document in WPS Writer: Launch WPS Office on your Mac and open your main document template.
- 2. Navigate to the Mail Merge Tool: Click on the 'References' or 'Mailings' tab at the top of the window and select 'Mail Merge'.
- 3. Attach Your Data Source: Click 'Open Data Source' and select your properly updated Excel or CSV file.
- 4. Insert Merge Fields: Click 'Insert Merge Field' to accurately place your dynamic recipient data into the document text.
- 5. Generate the Documents: Click 'Merge to New Document' to generate a fresh file populated with the latest recipient data.
Frequently Asked Questions
Why does Word keep showing old mail merge data?
Word caches the linked data source for performance reasons. If you modify the source file while the Word document is still open or without refreshing the connection, Word may continue using the previously cached data instead of pulling the latest updates.
How do I refresh a mail merge list in Word for Mac?
To refresh the list, you need to navigate to the 'Mailings' tab, click on 'Select Recipients', choose 'Use an Existing List', and re-select your updated data source file to force a connection refresh.
What should I do if 'Edit Recipient List' is grayed out?
If 'Edit Recipient List' is grayed out, it indicates that no data source is currently attached to the document. You must click 'Select Recipients' to attach an Excel or CSV file first.
Can I use a CSV file instead of an Excel file for mail merge on a Mac?
Yes, both Microsoft Word and WPS Office fully support CSV files as data sources for mail merge. Just ensure the CSV file is properly formatted with clear column headers in the first row.
