Problem Merging Field with text & numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 25 Aug 2005 15:29 GMT

I have an Excel File. It contains a column labeled "Room"

It has entries such as:

D213
C314
315
A316

When I try to merge it, the only one that merges properly is the one without
any letters. The rest say just say 0.

I tried formatting the cell in Excel so that they are text, but that didn't
make any difference.

How can I fix this?

Thanks,
Glenn

Reply to this Message

Doug Robbins - 25 Aug 2005 18:50 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" After doing that,
when you attach the data source to the mailmerge main document, you will be
presented with a number of options for the way in which the connection
should be made. Try the DDE option.

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 have an Excel File. It contains a column labeled "Room"
>
[quoted text clipped - 17 lines]
> Thanks,
> Glenn

Reply to this Message

Rate this thread: