Send Mass Email with VBA

[Yolandivdberg2]

Good day,

Attached is my test workbook, as you can see I already have a working VBA code, but what I need is the VBA to send one email per rep with all relevant data, instead of 10 emails to each rep

how do I alter my Code for this?

[vba_php]

no idea why you are creating a temp file with this:

Please Login or Register  to view this content.

there's no need for that. literally the only thing you need is this routine:

Please Login or Register  to view this content.

and the simple looping of a range to pull your email addresses.

[Logit]

.
This is part of the code. Review the download example workbook for remainder :

Please Login or Register  to view this content.

https://www.amazon.com/clouddrive/sh...owPAA3GGiTyBuO