Mail Merge looping through records

R

ram

HI

I'am using the code below to check or uncheck a box based on the value in a
merged field. I don't know how to loop through all the records. it only
compares the value once and not for each record

With ActiveDocument
If .MailMerge.DataSource.DataFields("Field1") > 0 Then
.FormFields("check1").CheckBox.Value = True
Else
.FormFields("check1").CheckBox.Value = False
End If
End With

End Sub
 
D

Doug Robbins - Word MVP

FormFields and mail merge are not compatible.

See the article “Combining FormFields and Mail Merge†on the following page
of fellow MVP Graham Mayor’s website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.



--
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, originally posted via msnews.microsoft.com
 
R

ram

Thank You for this information- I'll continue to use the checkbox symbol with
If then.
 

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