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

I guess the questions here are:
1. why are you looping through the records?; and
2. what is your SQL statement?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I guess I've not got that far yet. I'm just wondering that if you (or anyone) were writing a basic mail merge macro, how would you get it to notice if you had unticked records in the recipient list? This side of things is new to me, so be gentle!

For a basic mailmerge macro that would honor your record selection, see the first macro in the Mailmerge Tips & Tricks 'Sticky' thread:
https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Wow thank you!