PDA

View Full Version : email automation



tkellymd
01-22-2018, 10:03 PM
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.

Logit
01-23-2018, 12:06 AM
Deleted ... error.

Logit
01-23-2018, 12:08 AM
Usually its something like ...

For i = 1 to 5
more code
more code
Next