L
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
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