I have a script that works to send an email out in which the user can select the attachment but I would like for them to be able to write out the subject and body because I'm not sure most of them would be able to properly edit the code. Also, the list to who they send the emails will always be changing so I would like it if somehow I could set it so it would read from Sheet2 of the workbook. I can put all the email address's right in column A but I want it so that it can read those emails, either from separate rows in a single column or a single row separated by commas. Thanks!
Here is the code I'm using: