SOLVED

Mail Merge - Excel to Microsoft word not working correctly

Regular Contributor

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.

3 Replies
best response confirmed by calof1 (Regular Contributor)
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.

Hi@Savia 

 

Thanks for your help, much appreciated.

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