Word merge sometimes cuts off words

[BAW]

I have a word merge document that contains one field with a "description".
For some reason, the full description is sometimes cut off (characters
limited?) when I complete the merge. Othertimes, and from other computers,
they show up complete. The source of my mail merge is an excel document and
the field is less than 255 characters.

In addition, sometimes a "" in excel shows up blank in the same merge, and
sometimes it shows up as zeros. It seems to have no rhyme or reason why it
is doing this. ANY ideas?

Thanks!

 

[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options and then on the General tab,
check the box against "Confirm conversions at open". Then, when you attach
the data source to the mail merge main document, try the DDE method of
connection.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[BAW]

Doug- I am not an expert on word mergers. What is the DEE method of
connection?

 

[Doug Robbins - Word MVP]

If you follow the steps that I suggested, it will be presented to you as an
option. You don't really have to know what it is. However, it stands for
Dynamic Data Exchange (DDE).

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP