Word Directory Merge does not pull in all data in Excel Cel

[Venus930]

I am doing a directory merge and there are some fields that contain a lot of
text data that is downloaded from an on-line system into an excel file. When
I perform the merge the final document will have only part of the information
that is contained in the cell. I have tried adding spaces to give it more
room. Suggestions?

 

[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options 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 main document, select the DDE method of
connection from the dialog box that will then appear.

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

 

[Venus930]

Thank you so much...it worked

From the Tools menu in Word, select Options 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 main document, select the DDE method of
connection from the dialog box that will then appear.

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