I have written a macro to create and email .pdf files of worksheets that have emails in cell E1. I can get it to work for one tab at a time but want to automate the create .pdf, email, and send to file for each worksheet with an email in E1. When I added the loop function I get a complile error, "Next without for." Not sure what I did wrong. Thank you for your help.
Reply With Quote
