I need a vba that sends a multiple different range to a different recipient for each range.
For example, I have a range in A1-F30, with an email address and subject in H14:H15.
Then a different range in A32:F62, with a different email address and subject in H45:H46
And so on with possibly 100 different ranges and email addresses.
Is there a vba that will send a different email to all of those email addresses, with the range in the body of the email?
Bookmarks