View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
BH BH is offline
external usenet poster
 
Posts: 14
Default Format Zip Codes Correctly for a Mailmerge

Thank you all very much! The Answer Box article explained how to use DDE, and
it worked! Greatly appreciate the your suggestyionsd and help.

"Bernard Liengme" wrote:

Dave has given you a complete answer but here is my 2 cents worth.
I did a quick experiment and did not lose the digits following the zero.
Indeed, how can the merge engine no take all the characters from a text
field?
I would make sure all the zips are formatted as text, resave the data file
with another name and start your mail merge again
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"BH" wrote in message
...
In Version 2003, for a mailmerge using data in Excel, how does one format
the
cells for the Zip Codes so that the Zip Code numbers starting with 0 will
appear in the word merge. For example, the Zip Code for Englewood, NJ is
07631, and if the Zip Code cells are formatted as Number, Special,
General,
or even programmed in Custom, the first digit "0" does not appear in the
merge, but the only the "7631" appears. On the other hand, if the Zip Code
cells are formatted as Text, only the first digit "0" appears in the
merge,
but not the remaining digits of the Zip Code.