[Steve Curtis]

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)

[Doug Robbins - Word MVP]

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.

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

"Steve Curtis" wrote in message
...
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)

[Steve Curtis]

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?

"Doug Robbins - Word MVP" wrote:

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.

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

"Steve Curtis" wrote in message
...
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)

[Doug Robbins - Word MVP]

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.

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

"Steve Curtis" wrote in message
...
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?

"Doug Robbins - Word MVP" wrote:

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.

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

"Steve Curtis" wrote in message
...
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)