Conditionals in Mail Merge label layout

  • Thread starter Thread starter Ed Sowell
  • Start date Start date
E

Ed Sowell

I'd like to skip the Country entierly if the data is blank or USA. How is
this done?

TIA

Ed
 
Use the following field construction:

{ IF { MERGEFIELD Country } <> "USA" { IF { MERGEFIELD Country } <> "" {
MERGEFIELD Country } "" } "" }

You must use Ctrl+F9 to insert each pair of field delimiters and you use
Alt+F9 to toggle off their display.

--
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, originally posted via msnews.microsoft.com
 
Thanks, Doug. Wierd! It would be clearer is there were explicit THEN and
ELSE.

I have a couple other questions, if you don't mind. When the Country field
is USA or empty I'd like to not have the extra empty line at the end. Is
there a way I can put a newline character in front of the Country merge
field so it is conditional?

Also, how can I specify a vertical centering within the label?

Thangs again.

Ed
 
If you understand the syntax it is clearer

{IF condition "do this" "else do this"}

To remove the blank line put the field on the previous line and add in the
paragraph break eg

{Mergefield City}{ IF { MERGEFIELD Country } <> "USA" { IF { MERGEFIELD
Country } <> "" "¶
{MERGEFIELD Country }" "" } "" }
With a paragraph break (press enter) where you see ¶

For the vertical centering. select the table and format > table > cell >
alignment.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Thanks, Graham. That did it. I tried something like that, but omitted the
unmatched double quote in front of the paragraph marker. Is that the escape
sequence for embedding literals in Mail Merge? Where are all these rules
written?

Ed
 
That's interesting. I didn't match it and it worked. I then put in the
matching one per your advice and it works too!

Ed
 
Back
Top