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

Tip: Looking for answers? Try searching our database.

Mail Merge with Conditional Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pmv464 - 19 Mar 2008 05:08 GMT
I am merging a excel doc with word 2003.  One of my columns has items giving
a unique(1 of about 10 different) scenarios.  In my word document, I have a
check box for each of the different scenarios.  I would like Word to be able
to identify and check the box next to one of the scenerios.  Is this possible?
macropod - 19 Mar 2008 07:52 GMT
Hi pmv,

You can do this with a series of IF tests on your column of Scenario data. If, for example, the checked scenario has a value of 1 to
10, then you could use:
{IF{MERGFIELD Scenario}= 1 Checked Unchecked}
{IF{MERGFIELD Scenario}= 2 Checked Unchecked}
...
{IF{MERGFIELD Scenario}= 9 Checked Unchecked}
{IF{MERGFIELD Scenario}= 10 Checked Unchecked}
where 'Checked' and 'Unchecked' are checked and unchecked checkboxes.

To create such one such field, position the cursor where you want the output to go and press Ctrl-F9 twice to create a nested pair
of field braces (ie '{{}}'), then fill the field coding as shown, replacing 'Scenario' with your scenario data name and the
'Checked' and 'Unchecked' with checked and unchecked checkboxes, respectively.

Cheers
Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I am merging a excel doc with word 2003.  One of my columns has items giving
> a unique(1 of about 10 different) scenarios.  In my word document, I have a
> check box for each of the different scenarios.  I would like Word to be able
> to identify and check the box next to one of the scenerios.  Is this possible?
pmv464 - 25 Mar 2008 01:53 GMT
Thanks so much for the info.  I have been working with these if tests.  I
have another question.  How is word able to identify these scenarios as have
the values of 1,2,3...10?

> Hi pmv,
>
[quoted text clipped - 16 lines]
> > check box for each of the different scenarios.  I would like Word to be able
> > to identify and check the box next to one of the scenerios.  Is this possible?
macropod - 25 Mar 2008 06:21 GMT
Hi pmv,

Q.  How is word able to identify these scenarios as have the values of 1,2,3...10?
A. By the numbers in the IF tests. As indicated in my previous reply, I'm assuming your data source has a Scenario field containing
a single number from 1 to 10 to indicate which scenario the checked box relates to.

Cheers
Signature

macropod
[MVP - Microsoft Word]
-------------------------

> Thanks so much for the info.  I have been working with these if tests.  I
> have another question.  How is word able to identify these scenarios as have
[quoted text clipped - 22 lines]
>> > check box for each of the different scenarios.  I would like Word to be able
>> > to identify and check the box next to one of the scenerios.  Is this possible?
 
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.