Pdf and email worksheet from Excel

[Sky188]

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?

 

[jolivanes]

Have a look at this site.

Mail from Excel and make/mail PDF files (Windows)

 

[BrianM45]

HELLO

Yes it is possible, but without any polite formula, nothing is less sure