Adding data from user form to email

Hi there,

I am trying to get a little more information on how to get this user form to function as I require it.

I have got to a stage now where I can make the user form send an email, the body of which I am working on getting to function. However I am unsure as to how to attach the details placed in the user form automatically into the email ready to be sent. I have attached a test work book & it's the sim refresh option that I am working on.

Would it be possible for anyone to assist with how to get the data input automatically?

Hi all,

Just to add in the code I think I'm working with that will send the email. I am getting an error

"Compile error
Expected end sub"

Please Login or Register  to view this content.

In the email body where you can see "Tel" and "Contract" these are the data I would like input from the form.

Form functions as expected now, just the code that's having issues

Please Login or Register  to view this content.

Updated now, this is getting an email through as expected and is formatted correctly. However I cannot get the signature section to work.

Nor do I know how to input the data from my form onto the email. Any help?

This worked perfect thanks!!

Any ideas as to why the signature isn't working?

Sadly not literally so close now to having this part of the project done aswell.

Any other ideas on a way to work this as this code is one I've plucked from google

Please Login or Register  to view this content.

God damn file path, literally missing the beginning \

Thanks a lot for the help bakerman, managed to get it all sorted and working as I want it to be now
+ rep

Solved! Thanks