Mail Merge - Excel to Microsoft word not working correctly

[calof1]

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 through the text.

I have made sure all the format is the same.

Does anyone know what causes this issue and how to fix?

Many thanks.

[#2 · Accepted solution]

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.

[#3]

Hi@Savia 

Thanks for your help, much appreciated.

[#4]

Hi..Did u get to know how to fix this? Pls help