My input mask applied to zip code field is ignored in mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do a mail merge from an access database to a MS word doc &
everything is working except that my 9-digit zip codes are not displaying the
hyphen. I know how to correct the problem in the label wizard but not for
this mail merge. Can anyone help?

Thanks!
 
When you went throught the input mask wizard, did you select the option to
save the data with the symbols in the mask or without the symbols in the
mask? If the layout in the Input Mask line is 00000-9999;;_, then the data
is saved without the hyphen in the actual data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format zip code (9) to use in Word merg doc 1
Leading zero from Zip Code not print on Label Merge 6
directory mail merge/Office 2007 1
Leading 0 in Mail Merge document 4
Adding a HYPHEN to a 9 digit zip code column 7
How to merge Excel address columns when some zips begin with zeros 4
Input Mask Won't Carry Over 3
Access 07 Rich Text Memo field to be exported to Word (Mail Merge) 0

Back
Top