Re: Zero dropping from zip codes in word mail merge

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 sheet. 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


.

Relevant Pages

  • Re: Table Column Width lost when pasting
    ... calculations are easier to achieve in an Excel table. ... Word MVP web site http://word.mvps.org ... Quin wrote: ...
    (microsoft.public.word.pagelayout)
  • Re: Showing todays date when the Excel value is zero
    ... Word MVP web site http://word.mvps.org ... > When I remove the date formatting from the Excel cell then the Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail merge by data categories
    ... tutorial document that accompanies it? ... Word MVP web site http://word.mvps.org ... excel 2007, nor in another machine with excel and word 2003. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Form Formula doesnt work if the result is ZERO?
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... I see that the problem is that any number multiplied by Zero is Zero ...
    (microsoft.public.word.docmanagement)
  • Re: Word documents from records in csv file?
    ... demonstrates how to convert a CSV format file to a table. ... Word MVP web site http://word.mvps.org ... Excel as an intermediary strikes me as easier. ...
    (microsoft.public.word.newusers)