Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2005

Tip: Looking for answers? Try searching our database.

Merge Field Truncated

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shannon - 02 Feb 2005 21:47 GMT
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
Doug Robbins - 02 Feb 2005 23:44 GMT
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?

Signature

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

> How do I keep the merge fields from being truncated?  So far, it only
> allows
[quoted text clipped - 4 lines]
> Thanks,
> Shannon
Shannon - 03 Feb 2005 04:07 GMT
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

> 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
[quoted text clipped - 8 lines]
> > Thanks,
> > Shannon
Doug Robbins - 03 Feb 2005 10:27 GMT
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?

Signature

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

> The mergefields are in an Excel spreadsheet, but I don't know that the
> cell
[quoted text clipped - 15 lines]
>> > Thanks,
>> > Shannon
Shannon - 03 Feb 2005 13:09 GMT
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 lipshitz" 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

> Where is that data truncated?  In the Word document?
>
[quoted text clipped - 20 lines]
> >> > Thanks,
> >> > Shannon
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.