Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Annemaart
 
Posts: n/a
Default formula's in mailmerge

I'm trying to do the following in my mailmerge:

I want to provide a header, only if a any of a number of variables is not
zero. If all of the variables are zero, I don't want to display the header.

I've tried the following:

{IF OR({MERGEFIELD variable1} "", {MERGEFIELD variable2} "") "HEADER" ""}

But that doesn't seem to work. Also I'll get stuck with this way of doing
things if I want to use more than 2 variables, since OR won't allow for more
than 2. van anyone give me an idea what to try next?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default formula's in mailmerge

See the example "Testing for a value in one of several fields."
at http://www.gmayor.com/formatting_word_fields.htm
--

Graham Mayor - Word MVP

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


Annemaart wrote:
I'm trying to do the following in my mailmerge:

I want to provide a header, only if a any of a number of variables is
not zero. If all of the variables are zero, I don't want to display
the header.

I've tried the following:

{IF OR({MERGEFIELD variable1} "", {MERGEFIELD variable2} "")
"HEADER" ""}

But that doesn't seem to work. Also I'll get stuck with this way of
doing things if I want to use more than 2 variables, since OR won't
allow for more than 2. van anyone give me an idea what to try next?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mailmerge with Access via DDE Jim Gilligan Mailmerge 0 November 22nd 05 01:21 PM
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
Textboxes in Mailmerge? zSplash Mailmerge 5 March 22nd 05 09:01 PM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd 04 11:26 AM


All times are GMT +1. The time now is 04:12 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"