Eliminate Access Mailmerge empty cells in printed document

[Guest]

I am making address labels and I have an address1 line and an address2 line
in my Microsoft Access 2000 database layout. When the address2 line is empty
it leaves a blank line on my mailing label. How can I make that line
disappear, if it contains no information?

 

[Guest]

Try an IIF statement --
IIF([address2] Is Null,[address1],[address1] & Chr(13) & [address2])