Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2007

Tip: Looking for answers? Try searching our database.

want word to choose a defined paragraph based on a value in merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Credit Guy - 25 Apr 2007 16:24 GMT
I would like to have a single word merge document but have a paragraph in the
letter change based on a value in a merge file. For example, the customer has
a credit rating of 1, he gets a nasty paragraph. If he has a 5 in the field
he gets the nice paragraph. It is the Word document that chooses which
paragraph to use will base it's decision on a predefined criteria. eg if
<<credref>> >3 then nice else nasty.
I am creating the merge file from a CIS system which determines the credit
value but I want word to choose the appropriate paragraph. I hear it can be
done but can't find it in help.
Doug Robbins - Word MVP - 25 Apr 2007 18:25 GMT
You would use and If...then...Else field for that purpose.

You can create it directly from the keyboard, using Ctrl F9 to insert the
field delimiters { }

{ IF { MERGEFIELD credref } > 3 "You are such a nice person for paying your
bills on time" "You dirty rotten scroundrel.  Pay up or else." }

Change the words within the quotes to suit your taste.  Use Alt+F9 to toggle
off the display of the field codes.

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 would like to have a single word merge document but have a paragraph in
>the
[quoted text clipped - 9 lines]
> be
> done but can't find it in help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.