Email Merge to include CCs, with 1 attachment instead of many

[Auslegung]

Long story short, I cannot do this any other way. I know there are more efficient ways of going about this, such as InfoPath, Acces, etc, but my hands are tied as I'm stepping into a legacy spreadsheet with a long history of being used a certain way.



That being said, I send weekly, separate emails to several different Providers and their Facilitators, containing a single mail merge attachment. To populate these mail merges, I've had to create a different mail merge for each Provider (this ought not be). I am doing too much of it manually because I can't figure out how to achieve what I need.


I need to do a mail merge from the 1 form (instead of a different mail merge for each Provider) that sends 1 attachment to each Provider, and CCs the Regional Coordinator (her name is Anna, let's say), and each Facilitator that is mentioned in that weekly form. With the obvious tools in MS Word, I can send

1. every single record
2. as a separate attachment
3. to 1 person

but I cannot send

1. Provider 1's records to only Provider 1 (then 2's to 2, 3's to 3, etc)
2. as a single attachment
3. and CC "Anna" and each Facilitator mentioned on the form

Please show me what I need to do (VBA, more advanced Mail Merge, etc) to make this work the way I need it to, and save me LOTS of time each week. Thanks!