Mail Merge In Microsoft Word.

[Guest]

I'm using Mail Merge to create labels for a Mailing list.
In most of the lists the City, State and Zip are in one field, and they work
fine and the labels are good.
In one list it's necessary to have the Zip in a separate field and the
problem here is that the Zip comes out with a period and zero after it. Eg if
the correct zip is 11145 the zip coming up in preview and on the printed
label is 11145.0
I have tried various formatting options and its still the same, and I have
found that any cell containing only numbers comes out the same, eg Social
Security numbers, telephone numbers etc. Even formatting the cells as text,
once only numbers are present, the problem is still there. Any ideas on how
to correct. Thanks. Mike

 

[Pegasus \(MVP\)]

Try a Microsoft Word or MS Office newsgroup.

 

[Robert Gault]

I'm using Mail Merge to create labels for a Mailing list.
In most of the lists the City, State and Zip are in one field, and they work
fine and the labels are good.
In one list it's necessary to have the Zip in a separate field and the
problem here is that the Zip comes out with a period and zero after it. Eg if
the correct zip is 11145 the zip coming up in preview and on the printed
label is 11145.0
I have tried various formatting options and its still the same, and I have
found that any cell containing only numbers comes out the same, eg Social
Security numbers, telephone numbers etc. Even formatting the cells as text,
once only numbers are present, the problem is still there. Any ideas on how
to correct. Thanks. Mike

Here is a comment from MS Word Help.
" To control formatting, press ALT+F9 to display field codes, and then
add switches to the merge field. For example, to display the number
"34987.89" as "$34,987.89," add the numeric picture switch (\#). To
print client names in uppercase letters, add the format switch (\*)"

There are additional instructions for \# showing how to remove any .0
entries.

 

[PA Bear]

Forwarded to microsoft.public.word.mailmerge.fields via cross-post.

 

[Graham Mayor]

See the relevant section at http://www.gmayor.com/formatting_word_fields.htm

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>