i want to use check box in mail merge

K

Kamra

In mail merge, the main document has a check box (check1). The value of this
check box need to come from data source. How do I do achieve this? I have the
value for check1 as X in the data source. But, the check box is not checked
upon mail merge. Please advice any suggestion.
 
D

Doug Robbins

You can't do this with a formfield type CheckBox. Set up an
If...then...Else statement that checks for the value of the mergefield and
if it is checked have it insert the appropriate symbol obtained by using the
Insert Symbol dialog. The easiest thing to do is initially set up the
If...then...Else so that it returns the values A and B and then toggle on
the field codes using Alt+F9 and in place of the A and B insert the
appropriate symbols. Then toggle off the field codes and execute the merge.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
K

Kamra

Thanks Doug. It did the trick. I am having another small issue. I changed the
main document to add footer and additional text. However, this document is
now actining as merged document. It does not take any value from data source.
I shall appreciate your help as I am new to mail merge.

Thanks again
Kamra
 
D

Doug Robbins

Are you sure that it is the main document? Does it have a datasource
attached to it? What do you see if you press Alt+F9?

If it's a mailmerge main document with merge fields in it, you will see {
MERGEFIELD field name }. If nothing changes, then it is not a mailmerge
main document.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top