How do you get New England Zip codes to export all five digits?

[Lisa5015]

I can't seem to get any New Englad Zip Codes to export all five digits - they
have a 0 (zero) at the front and it hold in excel but won't reproduce in Word.

 

[Graham Mayor]

You need a formatting switch on your Word field -
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Lisa5015]

I'm basically lost. I don't know where to start. Do you have a screen capture
I could reference? I know how to do a mail merge but then it comes to the {}
things, I dont know how to get there.

I need to start from scratch on this one. Could you walk me through it?

 

[Graham Mayor]

Press Alt+F9. Your display will change from <<Zip>> to {Mergefield Zip}
Add the switch eg {Mergefield Zip \# "00000"}
Press F9 to update then ALT+F9 to toggle the display back again
If you need to create fields by hand the CTRL+F9 creates the brackets - the
rest is types from the keyboard.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter A]

I'm basically lost. I don't know where to start. Do you have a screen capture
I could reference? I know how to do a mail merge but then it comes to the {}
things, I dont know how to get there.

I need to start from scratch on this one. Could you walk me through it?

If the data are originally in Excel, you need to enter the zip codes as
text rather than a number - which causes leading zeros to vanish, as you
have found out. You can do this 2 ways, a cell at a time by entering an
apostrophe before the zip '012324, or a bunch at a time by using the
format, cells command to assign the Text format to the cells (before
entering the data).

 

[Lisa5015]

THANK YOU SO MUCH! Usually all I need is a walk-through!

 

[Graham Mayor]

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>