Send Data from Userform to Worksheet AND Send Userform fields in Email

  • Hi All,


    I have used a database template from this site and changed it to suit my needs but I have a bit of a problem with some of the code. I know how to update the worksheet with the relevant userform text fields and in another project I did I have successfully sent userform text fields in the body of an email.


    For this project I want to update the worksheet AND send an email at the same time. However, using the two pieces of code together is causing an error that I can't seem to solve (using my very limited vba knowledge!). The code I am working on is below and I have highlighted the line that is getting the error message. Can anyone help with a solution?


    Thanks in advance!


  • Re: Send Data from Userform to Worksheet AND Send Userform fields in Email


    Hi All,


    I have now solved this problem so no longer require any assistance. If anyone is interested, it was all down to the order of the code. The code to send the email had to be run before the code to save to the worksheet.


    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!