How to skip printing a blank address line in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awf3 - 20 Dec 2005 22:03 GMT

I can't find help for printing mixed 3 and 4-line addresses in mail merge. It
seems there should be a switch to place after the merge field name.

Reply to this Message

Graham Mayor - 21 Dec 2005 06:35 GMT

Conditional fields will work

{Mergefield Address1}{IF {Mergefield Address2} <> "" "
{Mergefield Address2}"}{IF {Mergefield Address3} <> "" "
{Mergefield Address3}"}{IF {Mergefield Address4} <> "" "
{Mergefield Address4}"}

Set the field boundaries {} with CTRL+F9 and substiture the names of your
address line fields.

Signature

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

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

> I can't find help for printing mixed 3 and 4-line addresses in mail
> merge. It seems there should be a switch to place after the merge
> field name.

Reply to this Message

Doug Robbins - Word MVP - 21 Dec 2005 06:41 GMT

Use and If...then...Else field

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD Address3 }" "{ MERGEFIELD
Address2 }x
{ MERGEFIELD Address3 }" }

use Shift+Enter to insert a line break in place of the x in the above. You
must use Ctrl+F9 to insert each pair of field delimiters {}

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 can't find help for printing mixed 3 and 4-line addresses in mail merge.
>It
> seems there should be a switch to place after the merge field name.

Reply to this Message