can I use mail merge to fill in check boxes

Z

Z

I am trying to create a form for employees to verify that the information we
have about them is correct. I use mail merge to fill out all of the
standard info for them to make things a bit easier like name, address,
phone, etc. but I would like to have check boxes for gender and pay type
(hourly/salary).

For example, if the database has "male" under gender, then I would like the
checkbox for Male to be checked or not based upon the info.

I'm VERY new at creating forms so any help would be appreciated.

Thanks.
 
D

D Yang

There may be some other elegant ways, but you could use the If...then... rule combines with special symbols that replicate checked/unchecked box

Daniel
 
Z

Z

Thanks, but I would like to know the more elegant way if there is one.

Z

D Yang said:
There may be some other elegant ways, but you could use the If...then...
rule combines with special symbols that replicate checked/unchecked box.
 
D

Doug Robbins - Word MVP

Use an If...Then...Else field that checks the entry in the Gender field and
inserts a checked box in the Male checkbox if the gender is male and an
unchecked box in the Female checkbox and vice-versa if the gender is female

To do this, at the location where you want the male check box to appear,
press Ctrl+F9 to insert a pair of field delimiters {} and inside them type

{ IF }

Then with the cursor before the closing }, press Ctrl + F9 again to insert
another pair of field codes and type in

( IF { MERGEFIELD Gender} = "male" "" "" }

Now, place the cursor between the first set of "" after "male" and from the
Insert Symbols dialog, insert a checked box Character Code 254 under the
Wingdings font. In between the second set of "", insert the unchecked box
symbol - Character Code 168 under the Wingdings font.

In the location where you want the female check box to appear, insert the
same field construction, including the symbols but change the "male" to
"female" (copy and paste is the easy way)

( IF { MERGEFIELD Gender} = "female" "" "" }


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
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