showing checkboxes and using mail merge

S

snew

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?
 
P

Peter Jamieson

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.
 

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