Reply
 
Thread Tools Display Modes
  #1   Report Post  
Shannon
 
Posts: n/a
Default Merge Field Truncated

How do I keep the merge fields from being truncated? So far, it only allows
six characters. I widened the Excel column, but it was already wide enough
for all of the records' entries to be visible.

Thanks,
Shannon
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

I assume that it is in the document that you are merging to that they are
being truncated. Where do you have the mergefields? Are they inside the
cells of a table with fixed cell dimensions?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shannon" wrote in message
...
How do I keep the merge fields from being truncated? So far, it only
allows
six characters. I widened the Excel column, but it was already wide
enough
for all of the records' entries to be visible.

Thanks,
Shannon



  #3   Report Post  
Shannon
 
Posts: n/a
Default

The mergefields are in an Excel spreadsheet, but I don't know that the cell
dimentions are fixed. You can see the whole word in the spreadsheet. How
can you tell if they are fixed and un-fix them?

Shannon

"Doug Robbins" wrote:

I assume that it is in the document that you are merging to that they are
being truncated. Where do you have the mergefields? Are they inside the
cells of a table with fixed cell dimensions?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shannon" wrote in message
...
How do I keep the merge fields from being truncated? So far, it only
allows
six characters. I widened the Excel column, but it was already wide
enough
for all of the records' entries to be visible.

Thanks,
Shannon




  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

Where is that data truncated? In the Word document?

Where are the fields in the Word document? Are they inside the cells of a
table IN THE WORD DOCUMENT?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shannon" wrote in message
news
The mergefields are in an Excel spreadsheet, but I don't know that the
cell
dimentions are fixed. You can see the whole word in the spreadsheet. How
can you tell if they are fixed and un-fix them?

Shannon

"Doug Robbins" wrote:

I assume that it is in the document that you are merging to that they are
being truncated. Where do you have the mergefields? Are they inside the
cells of a table with fixed cell dimensions?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shannon" wrote in message
...
How do I keep the merge fields from being truncated? So far, it only
allows
six characters. I widened the Excel column, but it was already wide
enough
for all of the records' entries to be visible.

Thanks,
Shannon






  #5   Report Post  
Shannon
 
Posts: n/a
Default

Yes, the data is truncated in the Word document, but not in a table. They
are in a text box ... uh, okay, I'm really embarrassed. Now that it's
morning and my head is on straight, I can see that two of the names in the
data for these fields are really unusual and just appear to be truncated.
Another name is actually misspelled, truncated by a typo. If you're
interested, they were "Meier, Bragn, and Wilbor." They just happened to be
the second, third and fourth entries which display one page at a time. The
other entries are all very short names to begin with. For kicks, I entered
"orville arnold knodle the third" as a first name and "icabod lip****z" as a
last name. It displayed beautifully. Thank you for your help. Actually,
your questions about tables knocked out a lot of other questions in my mind
as to why this seemed wrong, so I started thinking in another direction--the
data. Great job!

Shannon

"Doug Robbins" wrote:

Where is that data truncated? In the Word document?

Where are the fields in the Word document? Are they inside the cells of a
table IN THE WORD DOCUMENT?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shannon" wrote in message
news
The mergefields are in an Excel spreadsheet, but I don't know that the
cell
dimentions are fixed. You can see the whole word in the spreadsheet. How
can you tell if they are fixed and un-fix them?

Shannon

"Doug Robbins" wrote:

I assume that it is in the document that you are merging to that they are
being truncated. Where do you have the mergefields? Are they inside the
cells of a table with fixed cell dimensions?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shannon" wrote in message
...
How do I keep the merge fields from being truncated? So far, it only
allows
six characters. I widened the Excel column, but it was already wide
enough
for all of the records' entries to be visible.

Thanks,
Shannon






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
Why is my merge data being truncated? sinplicity Mailmerge 9 August 1st 06 10:33 AM
Date Field in Merge Document Karen Hart Mailmerge 35 March 29th 05 12:38 PM
Merge field in table of contents Richard Eggleton Mailmerge 0 February 2nd 05 12:12 AM
Home Phone field not getting picked up in Merge Cathleen McGuire Mailmerge 4 January 7th 05 03:13 AM
suppress invalid merge field word 2003 Mike Mailmerge 3 December 9th 04 11:13 AM


All times are GMT +1. The time now is 05:28 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"