View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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!