Truncated data when merging from MS Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laura Slade - 20 Aug 2003 18:46 GMT

I have a 5 paragraphs of marketing copy per product in a
Excel spreadsheet to merge into various Word docs.

Column 1 - in English truncates the data after 255 chars
Columns 2-5 (various languages - generally longer than the
English) all mail merge in completely

I am baffled

Please help

:-(

Reply to this Message

Cindy Meister -WordMVP- - 21 Aug 2003 14:37 GMT

Hi Laura,

> I have a 5 paragraphs of marketing copy per product in a
> Excel spreadsheet to merge into various Word docs.
[quoted text clipped - 4 lines]
>
> I am baffled

So am I. Generally, Excel will always cut off at 255
characters.

Which version of Office to you have? Do you know what kind of
data connection you're using to link in the Excel data?

If you insert a new column before Column 1, above, and fill
it with nonsense entries, does that make any difference how
mail merge handles that data that is in the former Column 1?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message