Based on what your most recent post, see below for possible fix. Also, if the emails will always be coming from you, you don't need an inputbox for username and password, but could choose to go ahead and hard code that. Assuming that in the fix below. Make sure you replace 'sheet 1' with the exact name of your workbook tab. Also, as long as you use xlsx in the naming and the attachment lines, you'll be fine. If you use below (uses xls), it should still work.
If this doesn't work, please provide error message details. Also... assume you can set to loop, but not sure the best way.
Also... if the list of recipients is unchanging, you could also hard code. Using inputbox allows that to be variable. Good luck!
Bookmarks