[Caroline]

Hello,
I am working on a mail merge with a merge field corresponding to a Excel
cell that can either contain numbers or both letters and numbers (the format
of those cells in Excel is set as 'text'). But in my Word doc, only the
strictly-numbers cells are showing. If there is a letter in the corresponding
cell of the Excel file, it will show as 0 in the Word doc.
How do I fix this?
Thank you,
Caroline

[Peter Jamieson]

See http://tips.pjmsn.me.uk/t0003.htm

- the DDE method method mentioned there may help. Otherwise, I think
you'll either have to modify your data source formatting in some way or
e.g. copy/paste your Excel table into a Word document and use that as
the data source.

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Caroline wrote:
Hello,
I am working on a mail merge with a merge field corresponding to a Excel
cell that can either contain numbers or both letters and numbers (the format
of those cells in Excel is set as 'text'). But in my Word doc, only the
strictly-numbers cells are showing. If there is a letter in the corresponding
cell of the Excel file, it will show as 0 in the Word doc.
How do I fix this?
Thank you,
Caroline