RangetoHTML Function:
Excel VBA Macro: Send Email With Multiple Tables In Body (Static and Dynamic Ranges). In this video, we go over how to send an email with one more than one range/table in the email body. We utilize the RangetoHTML function in order to do this. We start with static ranges and create are own function that returns a range to deal with dynamic ranges.