Thank you so much for the help.
I tried the micro Logit has provided but unfortunately didn't work for my project. This might work if I was sending the same page to all the recipients, with the same info on it. In my situation metrics will be different for each associate and each associate will only receive their own data. In addition data will be large and be changing every day.
Associate A,
Associate B,
Associate C...
Appropriate email addresses in column A

Thanks again