Re: Zero dropping from zip codes in word mail merge

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

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: Zero dropping from zip codes in word mail merge
    ... Word MVP web site http://word.mvps.org ... still lost the zero, ... if you have fewer than around 63 columns, copy/paste from Excel ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word was unable to open the data source
    ... I would expect DDE to work OK in Windows XP - it is OK here, ... You can try to ensure that only Word and Excel are open and see if that makes any difference. ... Excel are blank but when merged show up as zero in Word which I would like to ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word was unable to open the data source
    ... I checked to make sure Excel is not ignoring other applications that use DDE ... also have zero as some values that I do not want blanked out. ... You can fix this problem by using "formatting switches" in Word: ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Zero dropping from zip codes in word mail merge
    ... change the way Word connects to Excel to DDE (I can't remember if Graham ... should I lose the zero from a zip code when creating envelopes and letters ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Insertion of 0
    ... Word MVP web site www.mvps.org/word ... > no value there it seems to place a zero into the mail ... > are deselected from the options menu in excel. ...
    (microsoft.public.word.mailmerge.fields)