View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

Insert a conditional field on the previous line e.g.

{Mergefield Addr1}{IF {Mergefield Addr2} "" "
{Mergefield Addr2}"}

Note the positions of the line break and the quote marks.
Field boundaries are inserted with CTRL+F9
--

Graham Mayor - Word MVP

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





Sayali wrote:
Hi,
I need to create Labels using Mail Merge. I have the following format
for the labels
First Name Last Name
Addr1
Addr2
Phone Number

I wanted to know how to supress a line if the data for that entry is
not available. Say for example if Addr 2 is blank then I want the
output to look like

First Name Last Name
Addr1
Phone Number

But I am getting the output that looks like this

First Name Last Name
Addr1

Phone Number


I am new at this so I wanted to know if there is any way in which I
can suppress the empty line?

Thanx in advance
Sayali