Send multiple Excel Workbooks to relevant recipients : I have around 40 individual reports saved as Excel workbooks, which need to be sent to 40 different groups of recipients. Is there a VBA macro or similar that could be used to send the emails to the necessary recipients without having to enter each email address for each workbook?