|
|
mailmerge maximum field size |
|
Author |
Message |
BNABill
|
Posted: Wed Sep 12 09:58:47 PDT 2007 |
Top |
Excel Misc >> mailmerge maximum field size
I am using Excel 2003 and Word 2003, taking data from Excel to Word to create
a document using Word mailmerge standard routines.
Some Excel cells containgn text data and it appeasr that when transferring
the data to Word, it becomes truncated if more than 256 characters. However
this truncation does not seem to be consistent as 300+ characters sometimes
transfers
so:-
1) are there actual field length limitations?
2) if so what are they?
3) is there some wotk arouund other than spreading daat across a number of
Excel cells?
Excel7
|
|
|
|
|
Dave
|
Posted: Wed Sep 12 09:58:47 PDT 2007 |
Top |
Excel Misc >> mailmerge maximum field size
Do you find that the difference (sometimes truncated, sometimes not) is when the
sending workbook is open?
>
> I am using Excel 2003 and Word 2003, taking data from Excel to Word to create
> a document using Word mailmerge standard routines.
> Some Excel cells containgn text data and it appeasr that when transferring
> the data to Word, it becomes truncated if more than 256 characters. However
> this truncation does not seem to be consistent as 300+ characters sometimes
> transfers
> so:-
> 1) are there actual field length limitations?
> 2) if so what are they?
> 3) is there some wotk arouund other than spreading daat across a number of
> Excel cells?
--
Dave Peterson
|
|
|
|
|
Rogwirral
|
Posted: Thu Sep 13 01:20:03 PDT 2007 |
Top |
Excel Misc >> mailmerge maximum field size
It appears to make no difference. To clarify - in the same merge operation,
one field moves across complete. The next field, in the adjacent (right) cell
only moves over 255 (256th ch is a space). Both Excel fields are formatted
the same (general). The first has 744ch and the second 678ch.
> Do you find that the difference (sometimes truncated, sometimes not) is when the
> sending workbook is open?
>
> >
> > I am using Excel 2003 and Word 2003, taking data from Excel to Word to create
> > a document using Word mailmerge standard routines.
> > Some Excel cells containgn text data and it appeasr that when transferring
> > the data to Word, it becomes truncated if more than 256 characters. However
> > this truncation does not seem to be consistent as 300+ characters sometimes
> > transfers
> > so:-
> > 1) are there actual field length limitations?
> > 2) if so what are they?
> > 3) is there some wotk arouund other than spreading daat across a number of
> > Excel cells?
>
> --
>
> Dave Peterson
>
|
|
|
|
|
|
|