Mail Merge Field cutting off text

C

Cal Expo

I have a user who is using Excel as the list and has a field with text in it
that he is merging to a Word document, problem is that about the last 15
words from the merge field is being cut off. Is there a character limit on
merge fields and if so are you able to increase the size??

Thank You!
Cal Expo
 
P

Peter Jamieson

It depends partly on the version of Word and Excel and how you are
connecting to the data source.

There's certianly a problem with Word 2002/2003 and probably 2007 where, if
the first 8 cells (rows) in that text column all have 255 characters or less
in them, all the cells in the column will be treated as "text" rather than
"memo" and any longer than 255 characters will be truncated. You might be
able to fix this problem using the DDE option described at

http://tips.pjmsn.me.uk/t0003.htm

Peter Jamieson
 

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

Top