How do I use mailmerge to check and uncheck the box in the word?

[Vishal]

I have created a datasource in Excel and trying to mail merge into Word. I
managed to mail merge all the data, except for checkbox.... for eg. if a
record has 1 in column x, I want the box to be checked and if its 0 I want it
to be unchecked.... Please tell me if this is possible in Mail Merge?

 

[macropod]

Hi Vishal,

You can't use a mergefield to toggle the state of a checkbox. However, you
can simulate it by embedding your mergefield in an equation field
incorporating an IF test coded like:
{EQ \x ({IF{MERGEFIELD MyData}= 1 X " "})}
where 'MyData' is your mergefield's name.

This uses an IF test to determine whether to output and 'X' or a pair of
spaces, and an equation field to draw a box around the result. You might
need to play around with the formatting a bit to get exactly the appearance
you're after.

Cheers

 

[Cindy M.]

Hi =?Utf-8?B?VmlzaGFs?=,

I have created a datasource in Excel and trying to mail merge into Word. I
managed to mail merge all the data, except for checkbox.... for eg. if a
record has 1 in column x, I want the box to be checked and if its 0 I want it
to be unchecked.... Please tell me if this is possible in Mail Merge?

In an indirect way you can do something like this. Look at "Displaying Yes/No
info" on this page

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail