View Single Post
 
Old 12-05-2023, 09:56 AM
Han Champion Han Champion is offline Windows 11 Office 2016
Novice
 
Join Date: May 2023
Posts: 2
Han Champion is on a distinguished road
Thumbs up

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.
Reply With Quote