Problems with IF statement

[Joe Di Giulio]

Hello,

I am attempting to cater for a blank address2 in a mail merge. I have
written the following expression:

{ MERGEFIELD Title } { MERGEFIELD FristName } { MERGEFIELD LastName }
{ MERGEFIELD Addr1 }
{ IF { MERGEFIELD Addr2 } = "" "" "{ MERGEFIELD Addr2 }
" }{ MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Postcode }


The intention is to enter Addr2 and a carriage return if Addr2 is not blank.
I have two problems with this at the moment:
1. The carriage return is not working
2. If the text for Addr2 is "Level 21" only 21 is being displayed.

I have included the spaces in the IF statement as it appears in my doc. Can
someone point out where I have gone wrong? I am using Word 2003

Thanks in advance

 

[Graham Mayor]

{ MERGEFIELD Title } { MERGEFIELD FirstName } { MERGEFIELD LastName }
{ MERGEFIELD Addr1 }{ IF { MERGEFIELD Addr2 } <> "" "
{ MERGEFIELD Addr2 }" }
{ MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Postcode


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Briza]

Thank you.
This worked however if address2 is blank it shows this:

Bob and Jane Smith
12 Microsoft Street

New York

Whereas I want it to put the new york line on the address2 line if blank
like this:
Bob and Jane Smith
12 Microsoft Street
New York.

So could you tell me how to modify the if statement to do this?
Regards
Briza

 

[Doug Robbins - Word MVP]

You must put the carriage return exactly where it appears in Graham's post

{ MERGEFIELD Title } { MERGEFIELD FirstName } { MERGEFIELD LastName }¶
{ MERGEFIELD Addr1 }{ IF { MERGEFIELD Addr2 } <> "" "¶
{ MERGEFIELD Addr2 }" }¶
{ MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Postcode


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

 

[Briza]

Thank you but how do I insert a carriage return.
What is the key or key combination in word 2007?

 

[Doug Robbins - Word MVP]

Use the Enter key

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

 

[Graham Mayor]

Press the enter key where ¶ is shown and nowhere else in the field
construction.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Briza]

Hmm..ok I'm still really confused about this eventhough it sounds so simple.
When I press the enter/return key on my keyboard it doesn't bring up the
carriage return symbol but rather goes to the next line. I notice if I go
insert --> symbols --> special characters from the menu there is a symbol
that represents a paragraph.

All I want to do is insert a 2nd line address (which might be a PO Box for
example) on a separate line by itself. Please could you clarify how to do
this?

 

[Doug Robbins - Word MVP]

Click on the ¶ button on the toolbar and then you should see a ¶ where you
pressed Enter.

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