Blank Postcode returns zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Guy - 19 Aug 2004 07:55 GMT

I have a client who has a mail merge referring to an
excel list. The list has postcodes that are not
formatted as numbers (text) but when the merge is
performed if the field was blank then a zero is returned.

I think they are using either XP or 2003.

Thanks.

Guy

Reply to this Message

Graham Mayor - 19 Aug 2004 09:02 GMT

See http://www.gmayor.com/formatting_word_fields.htm
You may need to trap the field error with a conditional field eg

{IF {Mergefield Postcode} <> "0" "{Mergefield Postcode}"}

Signature

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

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

> I have a client who has a mail merge referring to an
> excel list. The list has postcodes that are not
[quoted text clipped - 6 lines]
>
> Guy

Reply to this Message