showing checkboxes and using mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snew - 18 Feb 2004 22:02 GMT

I have a preprinted form that I am wanting to merge
employee information into. Is there a way that I can
print only the merged information without printing the
full document? (E.g. Sue Smith; rather than First Name:
Sue Last Name: Smith) I know there is a feature under
Tools that will allow me to print data only for forms, but
this feature does not print the information from the
regular merge.

It was suggested that I change the font of the part I
don't want printed to white. This works ok with the the
words, but I also have checkboxes and want to be able to
check the boxes where applicable. If I change the font,
the boxes will not appear.

Any ideas?

Reply to this Message

Peter Jamieson - 19 Feb 2004 07:08 GMT

You could unprotect the form and use som VBA to convert the checkboxes to
ticks (or blanks) and crosses, e.g.

Sub ConvertBoxesToChars()
Dim oFormField As Word.FormField
For Each oFormField In ActiveDocument.FormFields
If oFormField.Type = wdFieldFormCheckBox Then
If oFormField.Result = 1 Then
With oFormField.Range
.Text = Chr(251)
.Font.Name = "Wingdings"
End With
Else
With oFormField.Range
.Text = Chr(252)
.Font.Name = "Wingdings"
End With
End If
End If
Next
End Sub

You would probably also have to set the font size and adjust the character
width in some way to ensure that following text did not shift slightly to
the left or right.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I have a preprinted form that I am wanting to merge
> employee information into. Is there a way that I can
[quoted text clipped - 12 lines]
>
> Any ideas?

Reply to this Message