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
"PoetsOnMars" <PoetsOnMars[ at ]discussions.microsoft.com> wrote in message
news:C319004F-04BC-4BDC-A36A-9094ED026BD7[ at ]microsoft.com...
[Quoted Text] > 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
|