I have a workbook with numerous worksheets and each worksheet has a different email address in A1. Is there a way to pdf each worksheet, save it with the name based on the value in A2, email the pdf to the email address in A1 via outlook, then move to the next worksheet and repeat until they’ve all been emailed?