Data truncated when merging from Excel to Word.

[Teresa]

My data is truncated when I am merging from an excel file to a word document.
I have merged this large of cells before with no problem, I'm not sure why
it's not working now. Can anyone tell me if there is a way to ensure the
field accepts all data, not just the first 260 characters.
Thanks,
Teresa

 

[Doug Robbins - Word MVP]

In Word, select Options from the Tools menu and then go to the General tab
and check the box against the "Confirm conversions at open" item, then when
you attach the data source to the mail merge main document, select the DDE
option.

The reason that it may have stopped working with the method that you were
previously using could be that there were no records with that many
characters in that field in the first so-many records in the data source,
which is used as a basis for determining the type of data that is in each
field.

--
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

 

[Teresa]

Hi Doug,
Thanks for the suggestion, however, that didn't work. It couldn't connect
through the DDE. The only difference is that the first workbook that I used
actually had those cells filled with a vlookup formula verses full text. I'm
going to try to go back to the vlookup and see if that works. I don't know.
If that works, I'll post the results, otherwise, I'll keep looking for a
solution.
Thanks,
Teresa

 

[Teresa]

My data is still truncated and nothing seems to be helping. I'm at a loss.
Does anyone have any suggestions?
Thanks,
Teresa