View Single Post
  #5  
Old March 17th, 2009, 03:06 PM posted to microsoft.public.word.newusers
Ed Sowell
external usenet poster
 
Posts: 13
Default Conditionals in Mail Merge label layout

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

"Graham Mayor" wrote in message
...
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
Word MVP web site http://word.mvps.org





Ed Sowell wrote:
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

"Doug Robbins - Word MVP on news.microsoft.com"
wrote in message
...
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

"Ed Sowell" wrote in message
...
I'd like to skip the Country entierly if the data is blank or USA.
How is this done?

TIA

Ed