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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vishal - 14 Nov 2006 19:51 GMT

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?

Reply to this Message

macropod - 14 Nov 2006 22:30 GMT

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

Signature

macropod
[MVP - Microsoft Word]

> 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?

Reply to this Message

Cindy M. - 24 Nov 2006 15:38 GMT

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

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 :-)

Reply to this Message