Forum Discussion
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 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.
- 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.
- 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.
