Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
If then statements
I have a document where I am merging name and address information for
customers and want to include text at the first line and then for the next record, a insert text based on whiich text was inserted at the first line. Like so: These customers requested information on your product via your advertisement. John SMith 123 Main St ANytown USA These customers requested information on your product line: Category: Tube Socks Sally Smith 124 Main St Anytown USA Here is what I have so far. {IF {MERGEFIELD CATEGORY}= "" " These readers have requested information via your advertisement. {MERGEFIELD "TEXT"}{MERGEFIELD "NAME"}" "These customers requested information on your product line: {MERGEFIELD "CATEGORY"} This is in front of the first record. Not sure how to change it for the next record and so on. Thanks for all info! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
If then statements
Assuming that the subject of this post and that of your earlier one, with
the subject of Email Mail Merge, are related, it sounds like you are trying to create a "one to many" type of communication (or perhaps that should be "many to one") that cannot really be done with mail merge. At least not out of the box. It can probably be done with a report in an Access database. However for some ideas on how you might try doing it with Word, 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 "LSivak" wrote in message ... I have a document where I am merging name and address information for customers and want to include text at the first line and then for the next record, a insert text based on whiich text was inserted at the first line. Like so: These customers requested information on your product via your advertisement. John SMith 123 Main St ANytown USA These customers requested information on your product line: Category: Tube Socks Sally Smith 124 Main St Anytown USA Here is what I have so far. {IF {MERGEFIELD CATEGORY}= "" " These readers have requested information via your advertisement. {MERGEFIELD "TEXT"}{MERGEFIELD "NAME"}" "These customers requested information on your product line: {MERGEFIELD "CATEGORY"} This is in front of the first record. Not sure how to change it for the next record and so on. Thanks for all info! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple "OR" statements in a single "IF" statement | Mailmerge | |||
limits on if statements | Mailmerge | |||
copy certain statements in a doc automatically to the end of doc | Microsoft Word Help | |||
IF statements always returning the "False" condition | Mailmerge | |||
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mailmerge |