How to combine IF and AND operator

G

Guest

Hi All,

I wonder if anyone could help me out. I am constructing a mail merge
document that reads from a database export file to get the source information.

I am wanting to combine 2 necessary conditions, which if are true, word will
insert some text using the INCLUDETEXT option.

I can get it to work using just one IF statement:

{IF {MERGEFIELD GftCampDsc}="Individual Donors" "{INCLUDETEXT gainsert.doc}"
""}

However, I need to turn this into an AND function, so that if the first
condition is true, AND a second MERGEFIELD called CatDesc01 is not equal to
the value "YES", then the INCLUDETEXT function is called.

This is for the charity I work for - it is for some letters we need to
produce.

I hope this is clear, but if any more information is needed, please let me
know.

I would be etremely grateful for any help anyone could provide.
 
G

Graham Mayor

{ IF{ Mergefield GftCampDsc } = "Individual Donors" "{ IF{ Mergefield
CatDesc01 } <> "YES" "{ IncludeText gainsert.doc" }" ""}" "" }


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

My web site www.gmayor.com

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top