Sending an email via UserForm

[Catsonheat]

Hi all,

I am trying to put A UserForm into my spreadsheet which when clicking the command button will bring up a UserForm with 1 text box to input information and two buttons "send email" and "cancel".

The cancel button is pretty self explanatory but the send email button should always connect to Outlook and send the contents of the textbox to a specific email address.

if it could display a message box once the email has been sent saying thanks that would also be great!

Unfortunately I'm having trouble getting it to work and this is my first attempt at UserForms. sadly I am struggling

Many thanks in advance!

[Catsonheat]

After much tweaking I have finally managed to get it working so I will be closing this down as solved.

[gmr4evr1]

Try this...it is bits and pieces of code that I use to send an email from a userform from within excel. The reason it is bits and pieces is because I believe this is the code you will need, the full code has a lot of extra stuff in it to pull data from excel and email it.

Please Login or Register  to view this content.

NOTE* This is UNTESTED as it does not contain all the code I use

[gmr4evr1]

Well shoot!

[Catsonheat]

Haha sorry Gmr! Many thanks for your reply though, it's still good to see and really helpful for me to see how your code is compared to mine and where mine could be improved!

I have added some rep for you

[gmr4evr1]

You may not want to change yours because I didn't test mine so "in theory" (in my mind) it should work as written, but it may not.
Thank you very much for the rep.