Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cal Expo Cal Expo is offline
external usenet poster
 
Posts: 1
Default Mail Merge Field cutting off text

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail Merge Field cutting off text

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
"Cal Expo" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge spacing is inconsistent btw merged field and text? Lucy Mailmerge 4 September 24th 05 01:47 PM
Mail Merge drops leading zeros from Access text field zips? LisaLynnGuy Mailmerge 1 August 25th 05 06:59 PM
Mail merge field different in datasource & insert a field menu Silvs Mailmerge 1 April 22nd 05 06:18 AM
Mail merge field isn't displaying all the text in a field. Can I . mojohubbard Mailmerge 3 March 28th 05 04:45 PM
Can you use mail merge when the address field is inside a text box Fran Mailmerge 1 December 4th 04 04:28 PM


All times are GMT +1. The time now is 09:29 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"