Outlook From Excel Sheet

Good Evening Folks!

I have been successful on making spreadsheet that will allow me to store contact lists on one sheet, then select which contact list to add to the BCC of an outlook email....
I am hoping to be able to use a field on the actual spreadsheet to populate the Subject, a field to add an attachment filepath, and a textbox1 to add the body of the email.
While I know I can use outlook directly, there are multiple reasons in my situation where this way is far more efficient. I have attached the workbook, if anyone might be
willing to point me in the right direction, that would be great.

So far, the only VBA I have needed is:

Please Login or Register  to view this content.

...and while i had this working, it does now seem to be hanging up on trying to send email

Originally Posted by KOKOSEK

Not tested too much:

Please Login or Register  to view this content.

This seems to give me all sorts of errors/issues. I did find some code last evening that gets me 99% of the way to where I am trying to go, with only (two) pieces of the puzzle not working:
1. When I select the dropdown for which list to select, i cannot figure out how to associate the name of the list as such that it will populate the email addresses that are beneath it, and 2, I am still trying to workout how to open file dialog to select an attachment OR place a file path in a field and have it attach. Either will work.

I have attached the revised workbook (module 4) being the one I am working with. If anyone could point out a set of directions for how to handle number 1 above, that would be awesome! (I am trying to take this in steps so that I can learn and stop bugging you folks

Originally Posted by KOKOSEK

As You remove textbox and merge cells into B11 instead (as field to write body of email), change this:

Please Login or Register  to view this content.

into:

Please Login or Register  to view this content.

Thank you! This works perfectly.... Might you have any idea how to link the email addresses to the dropdown?

Hi jjward,

On the attached I have demonstrated this using range names, I have also included the attachment piece.

Hope this helps