Hi Experts
in sheet 1 there is a list of recipients and the name of the sheets. Other sheet contain data to be send to recipients.
My requirement is a macro that will send each sheets to the recipients as per the list in Sheet 1
Attached a workbook for ref.
Bookmarks