View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Smitty Smitty is offline
external usenet poster
 
Posts: 12
Default Format a mail merge doc address 2 fields are needed insome l

Thanks for the advice. I've revisited my letters and am still having a problem.

How do I do this? I tried to use the "If..Then...Else" Option in the
"Insert Word Field" Drop down menu from the Mail Merge Toolbar, but I must be
doing something wrong. I have 3 menus at the top: "Field Name" "Comparison"
and "Compare to". "Field Name" allows me to choose Address 2 and "Comaprison"
allows me to choose is blank, but the "Compare to" choice is not a drop down
menu, so I have to type something in there. And then below that is a blank
space for "Insert this text".

I tried to paste your { IF { MERGEFIELD address2 } = "" { MERGEFIELD
nextfield } { MERGEFIELD address2 }{ MERGEFIELD nextfield } } in, but I am
not getting the result I need. Please help again...

Thank you

"Doug Robbins - Word MVP" wrote:

Use an If...then...Else... field that checks if address 2 is blank. If it
is, have it insert the next field. If it is not, have it insert address2
followed by a carriage return and the next field

{ IF { MERGEFIELD address2 } = "" { MERGEFIELD nextfield } { MERGEFIELD
address2 }ΒΆ
{ MERGEFIELD nextfield } }

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

"Smitty" wrote in message
...
I have a bunch of letters and my address 2 field has a suite or apartment
number. I want the address 2 field to go below the address 1 field, but
not
all of the letters reqiure an address 2 field. How do I avoid having a
blank
space in the letters where address 2 should go, but there is no address 2
to
insert in that specific letter? If the field code is used in the main
letter
before I merge it, once it's merged I have blank spaces in some letters
because there is no information for that field code. Please help...