Mail Merge Question

[msnews.microsoft.com]

Every month I send out a similar letter to all clients with their invoices.
Some clients have a "carbon" copy to mail to another person. Each month I
set up an Excel sheet with Company, Contact First, Contact Last, Address 1,
Address 2, City, State, Zip, Greeting, cc as header info.

My question is ... how do I get the cc to appear in the merged letter
**only** on those letters which require such?

 

[Suzanne S. Barnhill]

You'll need to insert the merge field inside an IF field.

 

[msnews.microsoft.com]

Thanks. I gathered that much, but how is the If statement to be phrased?
I've used them in excel, but no experience using If statements in Word.

 

[Graham Mayor]

Let us know the condition under which you determine whether a cc is required
and where you get that cc information from.

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[msnews.microsoft.com]

I have cc: as a Field Entry. If field is blank, no cc is required, if cc
has text, then cc required. I am told whether a client requires a cc to be
sent. Usually it is an insurance company paying a bill and the cc goes to
the client.

Thanks

 

[Graham Mayor]

If there's nothing in the field then nothing will appear in the document -
but I guess there's more to it than that? I suspect you want to add some
text so:

{IF {Mergefield cc} <> "" "cc: {Mergefield cc}"}

should put you on the right lines

The syntax is

IF test = condition "do this" "otherwise do this"

The otherwise bit is not required if it is to be blank.

Use the correct fieldname in the condition and insert the field boundaries
with CTRL+F9. They are not simply typed from the keyboard.


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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[msnews.microsoft.com]

Thank you I will try this!

I appreciate the assistance
Marcia