View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 0 value in mailmerge field

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" wrote in message
...
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