I need a VBA macro to select certain rows in a worksheet and email that as an attachment. In the attached sheet the macro should select email address from column BA and mail the selected rows to that e-mail address.
It should first select all rows with the same address in column BA and send that selection as an attachment to that address, then select all rows with the next email address and email that and so on for all email addresses available in column BA.
I use Outlook 365
Bookmarks