Mail merge cuts off some text, how do i fix this?

K

k&p

I have a report that pulls info into excel in preparation for a mail merge
report in word.

One of the mail merge fields contains a string of text that is 279
characters (including spaces).

When merged into the Word document, it seems to cut it off at 255 characters.

Is there a limit to how much text I can import into a mail merge document?
If not, is there a way to fix this?

Thank you in advance!
 
K

k&p

Found another post that was dealing with the same issue.
Here's the instructions from the other post. Works great!

From the Tools menu in Word, select Options and then go to the General tab
and check the box against "Confirm conversions at open" Then when you
attach the data source, choose the DDE option in the dialog box that asks
you for the method by which the connection to the data source should be
made. I think that this will overcome the 255 character limit that you are
up against at the moment.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Mail Merge - Directory Format 1
Text Form Fields Dissappear when I do Mail Merge To New Document 2 2
Word Form Fields in a Mail Merge Document 3
How do I retrieve my original document from Mail Merge? 2
How do I convert a mail merge document to a standard document? 2
Mail Merge of 97 & 2003 docs into 2007 3
How to Merge data from an ascii file into a Word Doc 15
Excel data being cut off 1

Top