[JohnH]

I have seen many post on how to suppress blanks lines in a merge ( address
line 2 is blank so don't print it). My Problem is I cannot figure out how to
write the If statment. I've seen posts that show the actual merge with the IF
in it but for the life of me I can not reporduce it. I've tried the Rule
option but I can't figure how to enter the merge fields.. I tried typing
directly into the doc but that gets treated as text. I know I'm just missing
some simple process step but I cannot figure it out or find it in help. MS
Word help does not seem to address this process. I can find unlimited methods
to skip records but not blank fields. The address block is not an option
because it cannot be mapped accurately with the data files I work with plus
it always comes in as 1.5 spacing and I can't turn that off. To make a long
story short hwo do I enter if address_line_2 is blank skip it and print/merge
the city,st,zip line right beneath address_line_1

Thanks
John

[Graham Mayor]

Use CTRL+F9 to enter each pair of field brackets then

{Mergefield Address_Line_1}{IF{Mergefield Address_Line_2} "" "
{Mergefield Address_Line_2}"}
{Mergefield City} etc


--

Graham Mayor - Word MVP

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




JohnH wrote:
I have seen many post on how to suppress blanks lines in a merge (
address line 2 is blank so don't print it). My Problem is I cannot
figure out how to write the If statment. I've seen posts that show
the actual merge with the IF in it but for the life of me I can not
reporduce it. I've tried the Rule option but I can't figure how to
enter the merge fields.. I tried typing directly into the doc but
that gets treated as text. I know I'm just missing some simple
process step but I cannot figure it out or find it in help. MS Word
help does not seem to address this process. I can find unlimited
methods to skip records but not blank fields. The address block is
not an option because it cannot be mapped accurately with the data
files I work with plus it always comes in as 1.5 spacing and I can't
turn that off. To make a long story short hwo do I enter if
address_line_2 is blank skip it and print/merge the city,st,zip line
right beneath address_line_1

Thanks
John

[Joe Murphy]

On 30 Nov, 14:35, JohnH wrote:
I have seen many post on how to suppress blanks lines in a merge ( address
line 2 is blank so don't print it). My Problem is I cannot figure out how to
write the If statment. I've seen posts that show the actual merge with the IF
in it but for the life of me I can not reporduce it. I've tried the Rule
option but I can't figure how to enter the merge fields.. I tried typing
directly into the doc but that gets treated as text.

Very likely, you need to insert the brackets around the field
properly. Are you typing the brackets?

Don't type the brackets. Instead, highlight the text you want to make
a field and hit Ctrl+F9. That will add the brackets and turn it into a
field.

So you start with, say, MERGEFIELD Date, select both words, hit Ctrl
+F9 and get {MERGEFIELD Date}.

Alt+F9 toggles the visibility of all fields, too.

Joe.

[JohnH]

YES!!! Thanks Graham & Joe. I almost got it. I'm still having trouble getting
the non blank addr2 on a seperate line without a blank line in between Addr1
& 2. I tried an enter and a shift enter but both produce a blank line between
addr1 & 2

Thanks so much.

"Graham Mayor" wrote:

Use CTRL+F9 to enter each pair of field brackets then

{Mergefield Address_Line_1}{IF{Mergefield Address_Line_2} "" "
{Mergefield Address_Line_2}"}
{Mergefield City} etc


--

Graham Mayor - Word MVP

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




JohnH wrote:
I have seen many post on how to suppress blanks lines in a merge (
address line 2 is blank so don't print it). My Problem is I cannot
figure out how to write the If statment. I've seen posts that show
the actual merge with the IF in it but for the life of me I can not
reporduce it. I've tried the Rule option but I can't figure how to
enter the merge fields.. I tried typing directly into the doc but
that gets treated as text. I know I'm just missing some simple
process step but I cannot figure it out or find it in help. MS Word
help does not seem to address this process. I can find unlimited
methods to skip records but not blank fields. The address block is
not an option because it cannot be mapped accurately with the data
files I work with plus it always comes in as 1.5 spacing and I can't
turn that off. To make a long story short hwo do I enter if
address_line_2 is blank skip it and print/merge the city,st,zip line
right beneath address_line_1

Thanks
John

[JohnH]

Actuall Graham I'm all set I think? It appears to be an anomaly? The first
time I look at a record with addr2 it shows a blank line between addr1 & 2
but if I cursor back and forth ti appeas fine. Appears fine in print as well.

Thanks Again
John

"Graham Mayor" wrote:

Use CTRL+F9 to enter each pair of field brackets then

{Mergefield Address_Line_1}{IF{Mergefield Address_Line_2} "" "
{Mergefield Address_Line_2}"}
{Mergefield City} etc


--

Graham Mayor - Word MVP

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




JohnH wrote:
I have seen many post on how to suppress blanks lines in a merge (
address line 2 is blank so don't print it). My Problem is I cannot
figure out how to write the If statment. I've seen posts that show
the actual merge with the IF in it but for the life of me I can not
reporduce it. I've tried the Rule option but I can't figure how to
enter the merge fields.. I tried typing directly into the doc but
that gets treated as text. I know I'm just missing some simple
process step but I cannot figure it out or find it in help. MS Word
help does not seem to address this process. I can find unlimited
methods to skip records but not blank fields. The address block is
not an option because it cannot be mapped accurately with the data
files I work with plus it always comes in as 1.5 spacing and I can't
turn that off. To make a long story short hwo do I enter if
address_line_2 is blank skip it and print/merge the city,st,zip line
right beneath address_line_1

Thanks
John

[Graham Mayor]

Merge to a new document to test.

--

Graham Mayor - Word MVP

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


JohnH wrote:
Actuall Graham I'm all set I think? It appears to be an anomaly? The
first time I look at a record with addr2 it shows a blank line
between addr1 & 2 but if I cursor back and forth ti appeas fine.
Appears fine in print as well.

Thanks Again
John

"Graham Mayor" wrote:

Use CTRL+F9 to enter each pair of field brackets then

{Mergefield Address_Line_1}{IF{Mergefield Address_Line_2} "" "
{Mergefield Address_Line_2}"}
{Mergefield City} etc


--

Graham Mayor - Word MVP

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




JohnH wrote:
I have seen many post on how to suppress blanks lines in a merge (
address line 2 is blank so don't print it). My Problem is I cannot
figure out how to write the If statment. I've seen posts that show
the actual merge with the IF in it but for the life of me I can not
reporduce it. I've tried the Rule option but I can't figure how to
enter the merge fields.. I tried typing directly into the doc but
that gets treated as text. I know I'm just missing some simple
process step but I cannot figure it out or find it in help. MS Word
help does not seem to address this process. I can find unlimited
methods to skip records but not blank fields. The address block is
not an option because it cannot be mapped accurately with the data
files I work with plus it always comes in as 1.5 spacing and I can't
turn that off. To make a long story short hwo do I enter if
address_line_2 is blank skip it and print/merge the city,st,zip line
right beneath address_line_1

Thanks
John