Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I conditionally merge based on a data value?
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I conditionally merge based on a data value?
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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article: http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "wayneb" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
Data Trucated in word merge with excel source | Mailmerge | |||
How Come? | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |