View Single Post
 
Old 06-04-2021, 07:42 AM
JamesWood JamesWood is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Nov 2020
Posts: 37
JamesWood is on a distinguished road
Question Mail merge macro that considers edited recipient list?

Hi guys


Just wondering how you would tackle a Word mail merge macro that takes into consideration if the 'Edit Recipient List' has some unticked recipients?


For recordNumber = 1 To totalRecord

With myMerge.DataSource
.ActiveRecord = recordNumber: .FirstRecord = recordNumber: .lastRecord = recordNumber
End With


Not sure how to get it to recognise if any recipients have been unticked, as the above code (just an excerpt of course) would obviously just process ALL the recipients.


Thanks a lot!
James
Reply With Quote