If then statements

L

LSivak

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!
 
D

Doug Robbins - Word MVP

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/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

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top