Kind Excel Experts,

I'm beating my head against my desk on this one, and I could use some input from folks with more experience than me. I'm trying to email information from a single data set to multiple recipients, with fields being filled as necessary. In the attached example:

  • The number of ABC Companies are variable, but the number of 123 Suppliers will remain stable.
  • The 123 Suppliers that deliver to the ABC companies will vary each period (we send these out weekly).
  • The letter is not a requirement. It's more of a hope. I have previously written code that emails data to multiple recipients, but the result is nowhere near as polished as I would like. It's above my abilities currently.


Right now letters are individually populated. We have a worksheet with 50+ letters that have to be manually changed each time an ABC Company changes a 123 Supplier. Those letters are printed and scanned as pdfs. The pdfs are then manually emailed, and the printed copies are mailed. I find the printing and mailing to be completely unnecessary, as by the time the letter reaches some of the recipients, we're already mailing out a revised letter.

I'm open to any suggestions, including non-VBA ideas, but my preference would be that everything remains in Excel due to the low user proficiency. To put things in perspective, I am the only one in the office that can perform a mail merge, so the fewer moving parts, the better. (That doesn't mean the others can't learn, but based on previous experience, it would likely require a minimum of four training sessions. The last training featured a 15 minute segment on finding the F4 key... Ain't nobody got time for that.) Any assistance would be greatly appreciated!

Sample.xlsx