Re: Zero dropping from zip codes in word mail merge

Assuming you inserted the field correctly using CTRL+F9 for the field
boundaries (or toggled the original field to edit the content) then simply
update the field (F9) and run the merge.

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Mary jane wrote:
Hi Graham,

okay now I am determined. I did try {mergefield Zip\#"00000"} and I
still lost the zero, what am I doing wrong?

"Graham Mayor" wrote:

DDE is covered in my web page -
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
however, the method suggested at
http://www.gmayor.com/formatting_word_fields.htm is simpler.

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Peter Jamieson wrote:
Thanks but isn't there an easy way,

There are only really three types of "easy" approach to fixing this:
a. change the way Word connects to Excel to DDE (I can't remember if
Graham covers that on the page you looked at, but you need to check
Word Tools|Options|General|"Confirm conversion at open" and
reconnect to your ***. DDE is the way Word used to work by
default in version 2000 and earlier)
b. if you have fewer than around 63 columns, copy/paste from Excel
to Word and use the Word document as the data source
c. use switches in the fields.

I mean it's a pretty basic thing, why
should I lose the zero from a zip code when creating envelopes and
letters when the column is set for zip code in excel?

I agree with you, but unfortunately that's the way it is now.

Peter Jamieson

"Mary jane" <Maryjane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:349C4726-900D-4610-98D8-507F721DD4D0@xxxxxxxxxxxxxxxx
Thanks but isn't there an easy way, I mean it's a pretty basic
thing, why should I lose the zero from a zip code when creating
envelopes and letters when the column is set for zip code in
excel? I don't recall this happening
to me in the past and I didn't expect to have to write code to fix
it

"Mary jane" wrote:

Merging from excel, field is set for zip in excel, dropping the
first zero
when merging into letters and envelopes. How do I change the
field attributes so word does not drop the zero in that field??

Thanks


.

Quantcast