Hi Paul,
Thank you for your kind efforts to make me learn mail merge filter.
Extremely sorry for not understanding apply mail merge filter. In ‘Mailing’ tab there is a option ‘Rule’ to filter the records. It’s my understanding. There is a option ‘skip it’ to exclude the records from mail merge but you said it’s not you mean. By using it I get the require output but I want to learn what is ‘apply mail merge filter’ a proper way from you. How to do it? I tried my level best to learn it but in vain. So how can I give you some evidence of ‘apply filter mail merge’? Please don’t mind. If I will learn it now then I hope that it will be my last post on this topic.
With ActiveDocument.MailMerge.Fields
.AddSkipIf Range:=Selection.Range, _
MergeField:="EMAIL", Comparison:=wdMergeIfEqual, CompareTo:="-"
.AddSkipIf Range:=Selection.Range, _
MergeField:="REMARK", Comparison:=wdMergeIfEqual, CompareTo:="Sent"
End with
Please guide me the proper way to ‘apply filter in mail merge’ positively.
Thanking you in anticipation.
Bookmarks