Mail merge result is "0"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PJ - 19 Nov 2007 21:35 GMT

I'm using an excel sheet to pull data from. One of the columns contains
numbers and letters combined. The mail merge result for this column equals
"0" when I merge. I have changed the formatting in the Excel sheet from
General to Text but get the same result. Why won't Word read the data in
Excel?

Thanks.

Reply to this Message

Doug Robbins - Word MVP - 20 Nov 2007 00:52 GMT

From the Tools menu in Word, select Options and then go to the General tab
and check the box against "Confirm file conversions at open" After doing
that, when you attach the data source to the mail merge main document, you
will be presented with a dialog asking you for the method by which the
connection should be made. Select the DDE option and try that.

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'm using an excel sheet to pull data from. One of the columns contains
> numbers and letters combined. The mail merge result for this column equals
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message