Forum Discussion

calof1's avatar
calof1
Iron Contributor
Feb 02, 2020
Solved

Mail Merge - Excel to Microsoft word not working correctly

Hi,   I have created a mail merge with a few hundred rows of data in excel to populate into Microsoft word, however for some of the records is not populating all of the text. It stops halfway throu...
  • Savia's avatar
    Feb 04, 2020
    Mail merge will use the first row of your file to guess at what the dataset looks like. If the first row has a short text field in those records then it might drop longer text lower down. To solve this, make a dummy first row filled with long text (e.g. =REPT("x",255)) to make sure that Word includes everything.

Resources