I have never done a mail merge, so I don't know the terminology to use.


I have an Excel sheet with several hundred email addresses. Each address may belong to one or more groups. For each group there is a column. When an email is sent to the group, only those addresses belonging to the group should be sent an email. The text for the email contents could be in Word documents or draft Outlook emails, whichever is easier. How is this accomplished?

Example:
Col A Col B Col C Col D
Group 1 Group 2 Group 3 Email
x x Nerd1@mail.com
x Nerd2@mail.com
x x Nerd3@mail.com

When sending to Group 1, Nerd1 and Nerd2 would be emailed.
When sending to Group 2, Nerd1 and Nerd3 would be emailed.
When sending to Group 3, Nerd3 would be emailed.

Does this need VBA to select which Group the email is being sent to?
How do I specify which draft email to send to each Group?