My current mail merge uses data in Excel 2010, and encompasses 115 merge fields, and one record. I am trying to update some large tables of data in a report, and wished to add 690 more merge fields rather than my current cut-and-paste work-around. I found three problems with this:
- Word doesn't list the Excel rangename in the list of objects in the workbook when selecting it from "Use Existing List". I was able to overcome this by simply referring to the worksheet with the data, and having the merge field range start in A1;
- Word doesn't list in the drop down boxes (Insert Merge Field) anything after the first 255 merge fields listed;
- Word doesn't recognize manually entered merge fields that occur after the first 255 merge fields.
This leads me to believe that there is a limit of 255 merge fields in Word 2010 from Excel 2010. Is this true? If so, since I will only ever need one record (this is automated data entry, rather than a traditional multi-receipient style mail merge), is there an alternate method to fully automate the transfer of 805 data items from Excel to Word?