Is there a limit (such as 255) on the number of merge fields in Word 2010 (from an Excel 2010 source) in a standard mail merge?

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?



Check the section 'How many fields (pieces of information) do you have for each record (the collection of the pieces of information)?' from following KB link which addresses this issue with solution and see if it helps:

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated December 2, 2019 Views 1,575 Applies to: