Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LSivak LSivak is offline
external usenet poster
 
Posts: 5
Default 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   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!








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple "OR" statements in a single "IF" statement [email protected] Mailmerge 0 June 22nd 06 12:39 PM
limits on if statements Robseym Mailmerge 4 March 7th 06 02:08 PM
copy certain statements in a doc automatically to the end of doc Big Daddy Fletch Microsoft Word Help 2 August 26th 05 12:33 AM
IF statements always returning the "False" condition JCSadie Mailmerge 4 February 28th 05 03:42 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 01:31 PM


All times are GMT +1. The time now is 05:14 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"