If then statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LSivak - 08 Nov 2006 22:12 GMT

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 to this Message

Doug Robbins - Word MVP - 09 Nov 2006 00:17 GMT

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

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 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
[quoted text clipped - 23 lines]
>
> Thanks for all info!

Reply to this Message

Rate this thread: