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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,215,884
Messages
6,127,567
Members
449,385
Latest member
KMGLarson

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