Mail Merge shortening excel fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Curtis - 17 Mar 2008 23:55 GMT

I am having a problem with the mail merge shortening a data field from excel,
I have done this merge multiple times from different worksheets, and it works
fine, but I have two worksheets where it chops it off. Does anyone have any
ideas (HELP, gotta love deadlines and problems)

Reply to this Message

Doug Robbins - Word MVP - 18 Mar 2008 04:24 GMT

From the Tools menu in Word, selection Options and then check the Confirm
conversions at open box. Then when you attach the data source to the mail
merge main document, you will be asked for the method by which the data
source should be attached. Select the DDE method. It is older technology
but will probably overcome your problem which appears to be caused by Word
considering the content of the fields in the first few records to determine
the type of data that they contain and then treating the whole of the
records on the basis of that determination, which is sometimes lacking.

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 having a problem with the mail merge shortening a data field from
>excel,
[quoted text clipped - 3 lines]
> any
> ideas (HELP, gotta love deadlines and problems)

Reply to this Message

Steve Curtis - 19 Mar 2008 18:46 GMT

Doug,

Thanks - that did work. I guess my new question is, why did this work so
well with the older technology and now with the new stuff, it doesn't - but
maybe that can only be answered by Microsoft?

> From the Tools menu in Word, selection Options and then check the Confirm
> conversions at open box. Then when you attach the data source to the mail
[quoted text clipped - 12 lines]
> > any
> > ideas (HELP, gotta love deadlines and problems)

Reply to this Message

Doug Robbins - Word MVP - 19 Mar 2008 20:43 GMT

Trying to be smarter is not always better. As a sixty plus year old
surrounded by thirty something year olds, I see that every day.

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

> Doug,
>
[quoted text clipped - 24 lines]
>> > any
>> > ideas (HELP, gotta love deadlines and problems)

Reply to this Message

Rate this thread: