Zeros in blank fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William Peters - 15 Sep 2004 03:34 GMT

I'm using Office XP and creating mailing labels using and
Excel database. Some fields in the label may be empty in
the database. Excel is printing "0" in those locations
instead of leaving them blank. This didn't happen with
the same form and data using Word in Office 2000. Any
suggestions for what I'm doing wrong. Tried {MERGEFIELD
[data]\F" "}. That results in 0 followed by contents
of " ".

Reply to this Message

Graham Mayor - 15 Sep 2004 08:10 GMT

Try
{IF {Mergefield [data]} <> "0" "{Mergefield [data]}"}

Signature

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

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

> I'm using Office XP and creating mailing labels using and
> Excel database. Some fields in the label may be empty in
[quoted text clipped - 4 lines]
> [data]\F" "}. That results in 0 followed by contents
> of " ".

Reply to this Message

wpeters - 15 Sep 2004 20:59 GMT

Thanks for the reply and I'll try it. I'll also check your web site.

> Try
> {IF {Mergefield [data]} <> "0" "{Mergefield [data]}"}
[quoted text clipped - 7 lines]
> > [data]\F" "}. That results in 0 followed by contents
> > of " ".

Reply to this Message

- 16 Sep 2004 17:35 GMT

That doesn't seem to work here. I tried to manually
enter other fields using ^F9 and manually entering the
code and that works with no problem. If I use the
statement below, after applying the database then
checking the code by toggling fieldcodes, part of the
code is missing and the "0" shows up in the code and on
the form in place of a field name. I've tried all sorts
of configurations of this and it will not work. Either
I'm going nuts in my old age or there is something
definitely wrong with the way Word XP handles this stuff.

BTW - Nice new home and great pictures. I retired to San
Diego and am doing remodel work but not a new home.
Thirty three years at Xerox wore me out!

>-----Original Message-----
>Try
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

Graham Mayor - 16 Sep 2004 18:10 GMT

Difficult to advise on this. You could change the method of connecting to
the data as illustrated in the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm, but if the empty
field produces 0 then trapping that in the manner suggested should work.

Signature

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

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

> That doesn't seem to work here. I tried to manually
> enter other fields using ^F9 and manually entering the
[quoted text clipped - 32 lines]
>>
>> .

Reply to this Message