Thank you for the response. I'm trying to automate this for an end user who is not very capable. If I understand correctly, I will attempt an Excel user form to allow the end user to select which group(s) to send an email to. The VBA code will filter the list for just 1 group's members, select the appropriate Word document and run the mailmerge. It will then loop and repeat until all the selected groups have been iterated through.
Its been several years since I programmed in VBA, so it looks like I have something to occupy my time over the holidays.
|