0 value in mailmerge field

[PoetsOnMars]

Have letters to send out but some addresses include unit number / letter
combinations that appear as zeroes in merged docs - tried various "solutions"
and some partially work, but have letter named units, number / letter
combinations, and letter / number combinations. How to make mergefields pull
what's in the dbase (excel 2003) cell into the merge doc? Thx / POM

 

[Doug Robbins - Word MVP]

In Word, from the Tools menu, select Options and then the General tab and
check the box against the "Confirm conversion at Open" item.

After doing that, when you attach the data source to the mail merge main
document, select the DDE option in the dialog box that will appear.

If that does not correct the problem, you may to to explicity convert the
data in the field in Excel to Text.

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