Hello VBA experts,
I have attached a workbook with an example of what I need to do.
I found the VBA code on this forum and am thankful to the writer.
I have set it up such that when you click the "Send_Email" button, the VBA code reads the addresses in cells "J2" and "K2" and sends that worksheet to those addresses. It works well.
Columns "J" and "L" will have a list of email addresses. I need to create an easy way for the user to select a few of those cells and send the email to all of them. One thought was to create some sort of check boxes or click buttons next to each address. Once the email is sent, all check marks would be cleared for next time around.
The idea is to modify the code, so that it reads all addresses next to the check boxes and add them to the "To" and "CC" list.
Any ideas, suggestions or solutions will be appreciated.
Thanks,
modytrane
Bookmarks