Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

can I use mail merge to fill in check boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Z - 13 Apr 2004 22:30 GMT
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 Yang - 14 Apr 2004 01:01 GMT
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 - 14 Apr 2004 16:35 GMT
Thanks, but I would like to know the more elegant way if there is one.

Z

> 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
Doug Robbins - Word MVP - 15 Apr 2004 10:10 GMT
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" "" "" }

Signature

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

> 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
[quoted text clipped - 8 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.