View Single Post
  #2  
Old May 21st, 2010, 06:39 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default IF conditions in fields leaves lines

Put the fields on the same line and insert the line break as part of the
result. eg

{ If { Mergefield Company } "" "{ Mergefield Company }"}{ If { Mergefield
Person } "" "¶
{ Mergefield Person }" }{ If { Mergefield JobTitle } "" "¶
{ Mergefield JobTitle }" }¶
{ Mergefield Address }

Press Enter only where you see ¶

--

Graham Mayor - Word MVP

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



"superfanny" wrote in message
...
Hi there,

When I'm using the IF function to determine which fields appear, how do i
make it so a failure to satisfy the condition does not skip a line?

For example, I have the following block at the top

[Company/Individual Member]
c/o [Person]
[Job Title]
[Work Address]
[City], [State] [Zip]

I want to set up the second line as follows

[If Company and Person , then"c/o [Person]", otherwise leave blank]

It has to include both Company and Person as conditions. The problem is if
the conditions aren't satisfied it leaves a blank line (unlike what fields
normally do, which is automatically jump to the next field). I've tried
different combos, but noething seems to be working. Is there a way around
this so there is no blank line? Thanks in advance.
--
Yousef