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 / Programming / September 2006

Tip: Looking for answers? Try searching our database.

issue with form check boxes and mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Angie E. - 05 Sep 2006 04:35 GMT
I'm starting to feel stupid and hope someone can help!  I have data in an
excel document that I would like to merge into a word document.  One of my
merge categories is Ethnic_Origin with White, Hispanic, Black, Native
American, and Other for choices.  I'd like that to merge into my word
document and be filled into checkboxes.  For example if the merge field has
White I'd like the checkbox by White (check1)on my form to be checked, if it
has Hispanic I'd like check2 checked.  Is this possible?  If so how?  I have
NO experience with macros if that's what it takes.

Thanks,
Angie
Doug Robbins - Word MVP - 05 Sep 2006 04:46 GMT
Where you want each of the checked or unchecked boxes to appear, you will
need to have an If...then...Else... field construction that checks for the
content of the Ethnic_Origin field and inserts either a checked box or an
unchecked box as required.  For the boxes use the appropriate symbols from
the Insert>Symbols dialog

White                        { IF { MERGEFIELD Ethnic_Origin } = "White"
[checked Box] [unchecked Box ]}
Hispanic                    { IF { MERGEFIELD Ethnic_Origin } = "Hispanic"
[checked Box] [unchecked Box ]}
Black                        { IF { MERGEFIELD Ethnic_Origin } = "Black"
[checked Box] [unchecked Box ]}
Native American        { IF { MERGEFIELD Ethnic_Origin } = "Native American"
[checked Box] [unchecked Box ]}

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm starting to feel stupid and hope someone can help!  I have data in an
> excel document that I would like to merge into a word document.  One of my
[quoted text clipped - 10 lines]
> Thanks,
> Angie
 
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.