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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Venus930 - 08 Apr 2008 15:45 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 08 Apr 2008 19:46 GMT

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.

Signature

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

>I am doing a directory merge and there are some fields that contain a lot
>of
[quoted text clipped - 4 lines]
> that is contained in the cell. I have tried adding spaces to give it more
> room. Suggestions?

Reply to this Message

Venus930 - 08 Apr 2008 21:57 GMT

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
[quoted text clipped - 9 lines]
> > that is contained in the cell. I have tried adding spaces to give it more
> > room. Suggestions?

Reply to this Message