Putting a dash between the zip code and the last four on a mail me

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 20 May 2006 02:49 GMT

I am doing a mail merge from an Access database. My zip code field has the
normal five digits for a zip code but sometimes has the last four digits as
well. However, I need a dash between these two when the last four digits are
there. I have tried field codes and if then statements. Nothing seems to work.

Thanks!

Reply to this Message

macropod - 20 May 2006 04:43 GMT

Hi Jonathon,

Two deal with both zip formats, you'll need to add some tests to the
mergefields in word. There are two ways you could approach this:
1
. copy the existing mergefield and make two copies of it, thus:
«ZipCode» «ZipCode» «ZipCode»
. select the second field and press Ctrl-F9 to embed it in another field,
thus:
«ZipCode» { «ZipCode» } «ZipCode»
. do the same with the third field, thus:
«ZipCode» { «ZipCode» } { «ZipCode» }
. select all of these fields and press Ctrl-F9 again, to embed the lot in
another field, thus:
{ «ZipCode» { «ZipCode» } { «ZipCode» } }
. within these fields, input the text as indicated:
. select all of these fields and press Ctrl-F9 again, to embed the lot in
another field, thus:
{IF«ZipCode»> 9999 {=«ZipCode» \# "00000'-'00000"} {=«ZipCode» \# 00000} }
2.
. copy the existing mergefield and make two copies of it, thus:
«ZipCode» «ZipCode» «ZipCode»
. select all of these fields and press Ctrl-F9 again, to embed the lot in
another field, thus:
{ «ZipCode» «ZipCode» «ZipCode» }
. select the second field and press Shift-F9 to expose its coding, thus:
{ «ZipCode» { MERGEFIELD ZipCode} «ZipCode» }
. do the same with the third field, thus:
{ «ZipCode» { MERGEFIELD ZipCode} { MERGEFIELD ZipCode } }
. within these fields, input the text as indicated:
{IF«ZipCode»> 9999 { MERGEFIELD ZipCode \# "00000'-'00000"} { MERGEFIELD
ZipCode \# 00000} }

In both cases, you need to be careful to maintain the spacing indicated
above.

Cheers

> I am doing a mail merge from an Access database. My zip code field has the
> normal five digits for a zip code but sometimes has the last four digits as
> well. However, I need a dash between these two when the last four digits are
> there. I have tried field codes and if then statements. Nothing seems to work.
>
> Thanks!

Reply to this Message

Jonathan - 20 May 2006 10:46 GMT

Thank you!! I'm up and running

> Hi Jonathon,
>
[quoted text clipped - 43 lines]
> >
> > Thanks!

Reply to this Message

Graham Mayor - 20 May 2006 06:41 GMT

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am doing a mail merge from an Access database. My zip code field
> has the normal five digits for a zip code but sometimes has the last
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message

Jonathan - 20 May 2006 10:47 GMT

Thank you...everything was good but there was one too many zeros on the
00000-00000. It worked once I put 00000-0000. Otherwise it has an extra zero
in there. Thank you soo much though. I would have never figured it out
without you!

> See also http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 5 lines]
> >
> > Thanks!

Reply to this Message

Graham Mayor - 20 May 2006 12:50 GMT

Damn! A typo. I'll fix that :(

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thank you...everything was good but there was one too many zeros on
> the 00000-00000. It worked once I put 00000-0000. Otherwise it has an
[quoted text clipped - 18 lines]
>>>
>>> Thanks!

Reply to this Message

Rate this thread: