Email userform textbox values

[rickblunt]

Greetings, just wondering if something is possible. I have used VBA to send emails containing the contents of worksheet cells, but I have never sent an email from a userform before. Has anyone ever tried to send an email from a userform where the email would contain the values from some of the userform textboxes?

The application would be that I am using userforms to document equipment condition, that part is all completed. Currently after the data goes in to the WB I then go back and create emails for all of the items that need to be repaired. The information that I am sending out in the emails is the same as what is being recorded on the userform. I got to thinking that wouldn't it be cool if when the data was sent to the WS it also did the email at the same time. I know that I could back door it and get the data from the WS, but the cells on the WS where the data goes to is dynamic. The data in the textboxes are static so to me it would be easier to code that for the email sub....

I have been searching the forums for something like this and haven't found anything yet. Does anyone out there think that this is possible?

Thanks

 

[rickblunt]

Follow up to my question....


Here is the code that I use to send WS cell data via email, and it works fine. But if I am going to try this from a userform then I do not know how to range the textbox values, tried simply substituting references but I am getting compile errors on the method so I am guessing that the EnvelopeVisible property is not appropriate for userforms...

Sub Send_PolisherEmail()
    
   ActiveSheet.Range("B2:B10").Select
     
   ActiveWorkbook.EnvelopeVisible = True
   
   With ActiveSheet.MailEnvelope
      .Introduction = "We have just installed the backup resin bed.  Please provide a new one at your earliest convenience. "
      .Item.To = "username@company email"
      .Item.Subject = "New resin bed needed"
      .Item.Send
   End With
   End Sub