Word adding ".0" tothe end of all zipcode mergefields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jayceejay - 11 Jan 2008 21:02 GMT

I am using Excel as my data source. I have a field entitled "Zip Code" which
is formatted as "Special -- 5 digit zip." Yet every time I attempt to merge
it to Word and print labels, Mail Merge insists on adding ".0" to the end of
each entry. How do I prevent this from hazppening???

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2008 22:02 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

Signature

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

>I am using Excel as my data source. I have a field entitled "Zip Code"
>which
[quoted text clipped - 3 lines]
> of
> each entry. How do I prevent this from hazppening???

Reply to this Message

jayceejay - 11 Jan 2008 22:51 GMT

Just as I feared.......Not something the average computer user will EVER
understand. MS Mailmerge used to be so easy. I learned it way back in
Office 97. And this seems like it should be a perfectly easy issue to
resolve. Unfortunately, all I can say after reading the link is
???????????????????

Sorry for the rant and thanks for the effort anyhow.

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 8 lines]
> > of
> > each entry. How do I prevent this from hazppening???

Reply to this Message

Doug Robbins - Word MVP - 12 Jan 2008 20:32 GMT

Nothing has changed in that respect from Word/Office 97 or earlier versions.
Excel does NOT STORE the information in the format that you have selected.

Signature

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

> Just as I feared.......Not something the average computer user will EVER
> understand. MS Mailmerge used to be so easy. I learned it way back in
[quoted text clipped - 17 lines]
>> > of
>> > each entry. How do I prevent this from hazppening???

Reply to this Message