Search code examples
excelms-wordmailmerge

Is there a way to remove the limitation of 255 columns when importing data for mail merge from Excel to Word?

I am using mail merge in MS Word for generating some documents and all the data comes from a specific Excel worksheet.

However it looks like that there is some kind of limitation for the columns you can use in your Excel worksheet for such mergefields and it turns out to be 255. When some kind of information is put in cells with columns greater than 255 these fields are not found by Word even though they have titles above them.

All my excel and word files are .xlsm and .docm and I am using MS 365 so I do not think it has anything to do with versions since they are the latest.

Do you have any idea what could be causing this limitation and is there a way of overpassing it?

Thank you in advance!

Solution

  • No, you cannot remove the limitation according to this. It says

    It depends on the data source.

    • For a data source that is a table in Word, it is 62.
    • For an Access Table\Query or Excel data source it is 255 or 256
    • A properly structured .csv file can have more.