maximum fields for mail merge 2010

Hi

 

I am having problems merging a document using word2010 . The fields are visible in the data source however they are not all availble for merging, the number is restricted.

 

Any help would be much appreciated

 

Thanks

 

Question Info


Last updated October 23, 2019 Views 1,512 Applies to:
What is the data source?  How many fields are there?  Is it only the fields after a certain number that are not available?  Is there something unusual about the field names?
Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
Screen shots by Snagit from www.techsmith.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Hi Doug

 

not sure of the exact number of fields however the fields available end at 255 . I have checked to see if there is an error in the data source, missing comma and have found no errors .

 

Is there a 255 restriction on fields in 2010 ?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

You didn't say what type of data source it is, but MailMerge can't use more than 255 columns in Excel despite the fact that since 2007, Excel has been able to use far more columns. The limit exists no matter which method you use to connect (DDE, ODBC, OLEDB).

As far as I know, the 255 limit applies to all data sources that Word accesses via the Jet/ACE provider (e.g. Access, Excel, text files that Word accesses via OLE DB or ODBC)

However, Word should work with a delimited text file with more than 255 columns as long as delimiter characters in the data are correctly "wrapped up" - e.g. if your data contains a comma, the field has to be surrounded by quotes. So you may be able to export your Excel data as a .csv file and use that.


1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.