View Single Post
 
Old 11-28-2023, 06:09 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The 'Mail Merge' feature of Word is not powerful enough to do your mail out in a single pass since you have a number of complicating factors that go beyond the default functionality. But you can certainly do it via a series of passes. Or if you were an advanced user doing this mailout regularly then you could create and use a macro to do it with a single click.

To get started, you need to prepare the various contents of the mailout as separate mail merge docs for each 'Group'. Once the group's email is set up, filter the merge source to remove any rows which don't have that column marked and do the mailout to those rows. Do the same for the other groups.

This means you do three mailouts (one for each group) and just filter the dataset to align with the group you want to send to.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote