How to skip printing a blank address line in mail merge

A

awf3

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.
 
G

Graham Mayor

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.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
D

Doug Robbins - Word MVP

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 {}

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top