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.