Conditional mail merge checkboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

franko - 09 Nov 2004 19:00 GMT

I'm creating a mail merge document that will attach to a MS Access database.
One of the merge fields is called "ClassType" and is a numberic value (1-6).
How do I create check boxes on the word document and have the appropriate
checkbox checked depending on the ClassType field value when I do the mail
merge?

I'm new to creating conditional mail merges, so any help would be
appreciated. I've placed six form checkboxes on the document but cant get
them to work with the mail merge.

Reply to this Message

tcptang - 09 Nov 2004 22:39 GMT

The codes below work in my document. Hope it helps.

With ActiveDocument.MailMerge.DataSource

' assumed that the merge field "ClassType"
' is the second field in the datasource.
' If it is the 3rd, then change the select statment to
' Select Case .DataFields(3).Value

' init
CheckBox1.Value = False
CheckBox2.Value = False
CheckBox3.Value = False

Select Case .DataFields(2).Value
Case 1
CheckBox1.Value = True
Case 2
CheckBox2.Value = True
Case 3
CheckBox3.Value = True
Case Else
' do nothing
End Select
End With

> I'm creating a mail merge document that will attach to a MS Access database.
> One of the merge fields is called "ClassType" and is a numberic value (1-6).
[quoted text clipped - 5 lines]
> appreciated. I've placed six form checkboxes on the document but cant get
> them to work with the mail merge.

Reply to this Message

Rate this thread: