Send Email With Prompt for Subject & Body

[nrichardson]

Hello,

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:

Please Login or Register  to view this content.

[nrichardson]

As usual, I mixed together a few codes I found and got it! Here is what I ended up with:

(I did need to select the Microsoft Outlook 14.0 Object Library in References though)

Please Login or Register  to view this content.