Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Initial zeros in zip codes getting dropped in Word mail merges
I'm doing mail merges in Word, using an Excel spreadsheet for the mailing
list. The zip code column in the spreadsheet is defined as zip code data and the cells display the initial zero correctly (e.g., Natick, Mass. is 01760). But in the mail merges, the zero gets dropped and the return address on the letter prints as 1760. How can I make the initial zero print? Along similar lines, is there any way to put two spaces between the state and zip fields? The merge function only puts one space between them. Thanks! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Initial zeros in zip codes getting dropped in Word mail merges
See the relevant section of http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Broadbrook wrote: I'm doing mail merges in Word, using an Excel spreadsheet for the mailing list. The zip code column in the spreadsheet is defined as zip code data and the cells display the initial zero correctly (e.g., Natick, Mass. is 01760). But in the mail merges, the zero gets dropped and the return address on the letter prints as 1760. How can I make the initial zero print? Along similar lines, is there any way to put two spaces between the state and zip fields? The merge function only puts one space between them. Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merges - zip codes don't print when they have hyphen, help? | Mailmerge | |||
Zero dropped in a mail merge. | Mailmerge | |||
losing zeros on zip codes when I create mail merge | Mailmerge | |||
zipcodes that begin with zeros or foreign codes in a mail merge H | Mailmerge | |||
preceeding zeros in postal codes of mail merge | Mailmerge |