View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Zip plus 4 not working in label mail merge

Try the following:

Use Alt-F9 to show your field codes.

Where you have something like

{ MERGEFIELD myzipcode }

change it to the following set of codes

{ SET myzip {MERGEFIELD myzipcode } }{ IF { myzip } 99999 "{ myzip
\#"00000'-'0000" }" "{ myzip \#"00000" } }

Each pair of {} needs to be the special field code braces that you can
enter using ctrl-F9. Everything else is ordinary text

Peter Jamieson

http://tips.pjmsn.me.uk

April wrote:
My source doc zip code column is formatted for Zip+4.

However, when I merge it for labels, the dash between the zip and the add'l
four numbers is removed and it becomes one long number.

Any suggestions?