Mail Merge: Text Limitation to 255 Characters? Can I change this?

Allison Hancock

New Member
Joined
Sep 21, 2013
Messages
14
I am having problems pulling the entirety of the text in some of the cells in Excel into the Word document while performing a mail merge. I am wondering if there is a limitation to how much text you can pull from Excel into Word, and if I can increase that limitation. It seems like 255 is the maximum number of characters it will pull from Excel.

I have already tried re-copying and pasting the information in the Excel cell.

And I have also tried recreating the entire Excel and Word documents.

Is 255 characters the maximum Mail Merge can handle? Can I change the maximum?
 
I hope that you have found a solution already(!), but since I am not seeing one above, I would like to share my solution: save the excel file as a csv file, instead of an excel workbook. I recommend keeping your excel workbook as your final file and saving the csv file as needed for merging. This will import all of the text without a character limit.
 
Upvote 0

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,216,578
Messages
6,131,524
Members
449,654
Latest member
andz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top