Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Merging variable length data to a table

Geek News

Merging variable length data to a table
THE Burg 10/6/2008 7:30:06 PM
I have a table set up in my main document and I'm merging data to it from and
Excel spreadsheet. The table is set to auto fit to conetents, Every thing
works fine for the first 9 records, where the "part number" field ends in 1
through 9. However when the 10th record (part numbers ending in 10 and
above) and up are merged, the last character is wrapped making the cell
taller instead of wider. I tried suggestion from Peter Jamison from
7/24/2008 and locked the row height. This simply kept the wrapped character
from showing -- now my part number ends in 1 instead of 10! I can widen and
lock the cell width as well I suppose, as a last resort, but I really would
like to be able to have the table resize as it does with normal data. Any
thoughts?
Re: Merging variable length data to a table
"macropod" <macropod[ at ]invalid.invalid> 10/6/2008 8:29:44 PM
Hi Burg,

Ideally, the table should be formatted so that its layout will be the same for all merged records. For your problem cell, this could
be done by widening the column, and/or by reducing the internal cell margin. You could also try setting the 'fit text' property for
the cell but, whilst that might result in long strings being compressed to fit on one line, it can also result in short strings
being overly stretched.

--
Cheers
macropod
[MVP - Microsoft Word]


"THE Burg" <THEBurg[ at ]discussions.microsoft.com> wrote in message news:B5729518-40F5-4CF2-9363-674B09B5FD04[ at ]microsoft.com...
[Quoted Text]
>I have a table set up in my main document and I'm merging data to it from and
> Excel spreadsheet. The table is set to auto fit to conetents, Every thing
> works fine for the first 9 records, where the "part number" field ends in 1
> through 9. However when the 10th record (part numbers ending in 10 and
> above) and up are merged, the last character is wrapped making the cell
> taller instead of wider. I tried suggestion from Peter Jamison from
> 7/24/2008 and locked the row height. This simply kept the wrapped character
> from showing -- now my part number ends in 1 instead of 10! I can widen and
> lock the cell width as well I suppose, as a last resort, but I really would
> like to be able to have the table resize as it does with normal data. Any
> thoughts?

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net