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