Mail Merge Field cutting off text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cal Expo - 20 Jun 2007 00:35 GMT

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

Reply to this Message

Peter Jamieson - 20 Jun 2007 19:56 GMT

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

>I have a user who is using Excel as the list and has a field with text in
>it
[quoted text clipped - 4 lines]
> Thank You!
> Cal Expo

Reply to this Message

Rate this thread: