How do I skip blank fields in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julia - 04 Aug 2005 00:23 GMT

I'm printing mail merged labels & some records have multiple address fields &
some only have 1 - how do a skip a blank field in a record. I can't seem to
locate something like "do not print blank fields" or "skip to next field if
blank".

Reply to this Message

Doug Robbins - 04 Aug 2005 05:24 GMT

Use a " Skip Record If" field. When you insert such a field there is a
dialog box that opens and allows you to input the conditions.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm printing mail merged labels & some records have multiple address
> fields &
[quoted text clipped - 3 lines]
> if
> blank".

Reply to this Message

Julia - 04 Aug 2005 15:16 GMT

Doug - that didn't help - it skips the entire record rather than just the
blank field.

> Use a " Skip Record If" field. When you insert such a field there is a
> dialog box that opens and allows you to input the conditions.
[quoted text clipped - 6 lines]
> > if
> > blank".

Reply to this Message

David - 04 Aug 2005 21:15 GMT

Try this...

Press Alt-F9 to show field code.
The insert code similar to this...

{ MERGEFIELD "CustomerAddress1" }{ IF { MERGEFIELD "CustomerAddress2" }<> "" "
{ MERGEFIELD "CustomerAddress2" }" "" }

The if statement checks to see if the second line of the address is blank or
not. If it is not blank then it does a carriage return then iserts the
second address line. If it is blank it does nothing.

Hope this helps

> Doug - that didn't help - it skips the entire record rather than just the
> blank field.
[quoted text clipped - 9 lines]
> > > if
> > > blank".

Reply to this Message

Rate this thread: