How do I conditionally merge based on a data value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wayneb - 29 Aug 2006 23:50 GMT

I would like to create invoices and use mail merge to fill in items that have
not been paid. If an item has been paid, there will be a specific value in
the field.

An example would be homeowners fee. If paid, the field will have 100. If it
is not paid, I want to print a line requesting payment.

Thank you.

Reply to this Message

Doug Robbins - Word MVP - 30 Aug 2006 04:33 GMT

Use an If...then...Else... field construction

{ IF { MERGEFIELD Fee } <> 100 "Please pay up" "" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to hid their display.

I suspect that there might be more to what you are doing than just this and
that you are probably trying to perform a "multiple items per condition
(=key field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

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

>I would like to create invoices and use mail merge to fill in items that
>have
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message

Rate this thread: