Using mailmerg to fill out forms to mail out

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick Maxon - 13 Dec 2004 21:59 GMT

I have created a form which I am going to mail out to members of a group. I
am merging from a member database to fill out the form as much as I can.
This is for renewing membership into the club. I have a field called
family/single in my database which has an "s" or a "f" in it. On my form, I
have two fields with checkboxes. One called Family and the other called
Single. Is there a way that I can interrogate the database field and place
an "X" in the appropriate checkbox on the form for family or single during a
merge?

TIA!

Pat

Reply to this Message

Doug Robbins - 14 Dec 2004 01:00 GMT

Use an If...then...else field. You will actually need 2 of them

In the Family Checkbox, use

{ IF { MERGEFIELD "family/Single" } = "f" "X" "" }

and in the Single Checkbox use

{ IF { MERGEFIELD "family/Single" } = "s" "X" "" }

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

>I have created a form which I am going to mail out to members of a group. I
> am merging from a member database to fill out the form as much as I can.
[quoted text clipped - 9 lines]
>
> Pat

Reply to this Message

Patrick Maxon - 14 Dec 2004 01:26 GMT

How do I put this "in" the checkbox? Macro... VB?

> Use an If...then...else field. You will actually need 2 of them
>
[quoted text clipped - 21 lines]
>>
>> Pat

Reply to this Message

Doug Robbins - 14 Dec 2004 02:34 GMT

For the "checkbox", use the cells of a table.

Signature

> How do I put this "in" the checkbox? Macro... VB?
>> Use an If...then...else field. You will actually need 2 of them
[quoted text clipped - 22 lines]
>>>
>>> Pat

Reply to this Message