Problem Merging Field with text & numbers

[Glenn]

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

 

[Doug Robbins]

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.

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