Auto-Format ZipCode with 4-digit extensions

[tyleri]

My problem is that in the tables the 4-digit extension for the zipcode shows: 90210-5555

But - when i perform a mail-merge into Word, it shows:

902105555

I have: 00000/-9999;; in the input mask. HOw can I get that dash to show up in the mail merge?

 

[WaltLukeIII]

Tyleri,

I did something where I have a address database and I want to take several fields for that record and move them to the header of a letter or print it to a label for an envelope. I did this

dim tempstring

tempstring = Name & (Chr(13)) & Address1 & (Chr(13)) & City & ", " & State & " " Zip & (Chr(13)) & Country

Then I moved all tempstring to the clipboard and could simply paste all of my info right where I wanted it. (I did the above with the press of a button.

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl

 

[WaltLukeIII]

I'm sorry I forgot to answer your question. I would do this

dim temp1, temp2, temp3

temp1 = left(zip,5)
temp2 = right(zip,4)
temp3 = temp1 & "-" & temp2

Then do whatever you like with temp3

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl