Mail Merge Question

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

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?
 
You'll need to insert the merge field inside an IF field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
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.
 
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
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
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
 
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
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Back
Top