Observe the field names in the header row. The goal is to do a mail merge with one letter per ID. 10.2 Mail Merge Open the Ch10DataFile and go to the MockarooCars sheet. Incorrect formatting of numbers can cause errors in the merge. Where I am getting stuck is utilizing an Excel file with two spreadsheets as sources of information.
#How to mail merge excel to excel zip
Also, make sure the sheets are clearly named, as you have to select the one you intend to use without being able to view it.
![how to mail merge excel to excel how to mail merge excel to excel](https://warwick.ac.uk/fac/soc/wbs/central/issu/help/kb/email/live/mailmerge/1.png)
If it's spread across multiple sheets, combine the sheets or perform multiple mail merges.
![how to mail merge excel to excel how to mail merge excel to excel](https://www.exceltip.com/wp-content/uploads/2015/06/image-235.png)
Put All Data on a Single Sheet: The mailing list data you intend to use for the mail merge must be on one sheet.