Excel to send email to two addresses in two cells? MSG box upon send?

Hi All,

I'm very new to VBA. I've made a simple form in excel for users to fill out with their information and their email address and their teammates email address. There is a button for them to click to send it in an email to a mailing list. I need to CC both email addresses provide and they are in different cells.

I've used the tips on http://www.rondebruin.nl to get as far as I have, but I'm not able to get the the email to send to two email addresses when they are in different cells.

I've also tried to get a validation check to run on the fields to make sure everything field has been completed before the email will send, but I can't figure that out either. Also, I would like a message to appear after the user clicks the submit button(like "This request has been submitted"), however, I can't figure out how to get this to work.

I've read through so many of the threads on here and tried so many of them. I've been working on this for 3 days, I think I am going crossed eyed! any help is much appreciated!

Here is my code:

Please Login or Register  to view this content.

Welcome to the forum.

Try:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Only disadvantage of this method is that when you want to send to more then 2 addresses your string will become really long.
That's why I would like to propose this alternative.

Please Login or Register  to view this content.

which you can easily expand just by replacing d6 with the last cell in the range you want to use.