mail merge excel to word text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emily - 01 Aug 2006 01:29 GMT

It seems there is a maximum allowable text length when merging from Excel to
Word. One of my merge fields is a text description that can range anywhere
from a couple sentences to an entire paragraph. It seems to cut off after a
certain number of characters. Is there any way I can fix this? I know you
can choose an unlimited text length when using the form textboxes, is there a
way to do the same in a mail merge?

Reply to this Message

Doug Robbins - Word MVP - 01 Aug 2006 04:25 GMT

From the Tools menu in Word, select Options and then go to the General tab
and check the box against "Confirm conversions at open" Then when you
attach the data source, choose the DDE option in the dialog box that asks
you for the method by which the connection to the data source should be
made. I think that this will overcome the 255 character limit that you are
up against at the moment.

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

> It seems there is a maximum allowable text length when merging from Excel
> to
[quoted text clipped - 7 lines]
> there a
> way to do the same in a mail merge?

Reply to this Message

Rate this thread: