View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default mail merge and zip codes

Hi,

Please refer to the earlier post dated 8/1/2007

Challa Prabhu

"LStout" wrote:

i have a mailing list in excell and i am trying to mailmerge it in word. but
if there is a 0 (zero) as the first digit in the zip code, it gets dropped in
the mail merge. i have already tried putting text(A3,"00000") A3 being the
cell in another column and then filling down, but it's still not working. any
suggestions?