Macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jamiks - 31 Dec 2007 22:26 GMT

We made a mail merge packing slip. We would like the item column to remain
blank if threre is no qty for it in the next column over.

any suggestions?

Signature

jami

Reply to this Message

Graham Mayor - 01 Jan 2008 08:15 GMT

You would use a conditional field. Assuming your field names are called Item
and Quantity then in the Item column enter
{IF {Mergefield Quantity} <> "" "{IF {Mergefield Quantity} <> 0 "{Mergefield
Item}"}"} this will only enter the item field if the quantity field has
content greater than 0. All pairs of field brackets are entered with CTRL+F9

Signature

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

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

> We made a mail merge packing slip. We would like the item column to
> remain blank if threre is no qty for it in the next column over.
>
> any suggestions?

Reply to this Message

Rate this thread: