i want to use check box in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kamra - 19 Sep 2004 22:09 GMT

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.

Reply to this Message

Doug Robbins - 20 Sep 2004 00:43 GMT

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.

Signature

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

> In mail merge, the main document has a check box (check1). The value of
> this
[quoted text clipped - 3 lines]
> checked
> upon mail merge. Please advice any suggestion.

Reply to this Message

Kamra - 22 Sep 2004 15:17 GMT

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

> 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
[quoted text clipped - 11 lines]
> > checked
> > upon mail merge. Please advice any suggestion.

Reply to this Message

Rate this thread: