Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Why do zip codes w/ leading zeros disappear when doing mail merge

Geek News

Why do zip codes w/ leading zeros disappear when doing mail merge
Dory 12/17/2008 4:11:01 PM
I use excel which contains zipcodes that begin with zero. When I merge the
spreadsheet for letters and labels, the zeros disappear (I get a four diget
zipcode instead of five).

I formated the column as a zip code, but it still doesn't work.
Re: Why do zip codes w/ leading zeros disappear when doing mail merge
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/17/2008 7:18:57 PM
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Dory" <Dory[ at ]discussions.microsoft.com> wrote in message
news:6E8CD218-35A2-4EF9-BFFD-A284CDACC944[ at ]microsoft.com...
[Quoted Text]
>I use excel which contains zipcodes that begin with zero. When I merge the
> spreadsheet for letters and labels, the zeros disappear (I get a four
> diget
> zipcode instead of five).
>
> I formated the column as a zip code, but it still doesn't work.


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net