VBA Userform - When submitted by email the attachment is blank.

Hi

I am very new to VBA and I am trying to create a userform which can be filled in and then when command button "submit" is clicked the completed form is emailed to myself. I have created the code for this but the userform is arriving as a blank attachment. As anybody had this problem before? if so could you please help?

Below is the code i am using

Many Thanks

Please Login or Register  to view this content.

Hi royUK, thanks for helping. My trainer advised me i could create a form and this form could be sent as an attachment. I used the code he sent me and although the userform does get sent, the form appears blank when opened. Can it not be done sending a complete form by email?

Any advise on how to proceed please?

Thanks, Do you mean build the form within excel not using VBA?

Thanks royUK, could you advise me of the code i should be using to get a pdf document or should i run a macro of me saving and emailing the document?

I have created the form in excel now and have put a button on the page. I want this button when clicked to send the document as an attachment to my email address. Is it a case of using the same code i had at the start of my thread?

Appreciate the help.