Specify Criteria for Mail Merge Recipients

[Lynn]

I would like to change the following macro so that it selects only those
people in the data source that do NOT have an email address (ie Email =
blank). Any suggestions? I will also need to know how to change it back to
Email = All.

Thanks!


Sub PrintMerge()
'

With ActiveDocument.MailMerge
.Destination = wdSendToPrinter
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
End Sub

 

[macropod]

Hi Lynn,

You can achieve this without a change to the macro, by incorprating a SKIPIF field into your mailmerge template. See Word's Help
file for details.