Zip plus 4 not working in label mail merge

[April]

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?

 

[Peter Jamieson]

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

 

[Peter Jamieson]

Missed a quote:

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


Peter Jamieson

http://tips.pjmsn.me.uk