Adding UserForm Data into the Body of an Email

Re: Adding UserForm Data into the Body of an Email

here is a sample of code I use that I have set to a Click event on a command button - the body of the message I have end users but in a text box , I set as textbox3.

Private Sub Email_Click()
Dim oOLook As Object
Dim oEMail As Object
Set oOLook = CreateObject("Outlook.Application")
oOLook.Session.Logon
Set oEMail = oOLook.CreateItem(0)
oEMail.Display
On Error Resume Next
With oEMail
.To = textBox1.Value
.CC = textBox2.Value
.BCC = ""
.Subject = ComboBox1.Value
.Body = TextBox3.Value
End With

Hello, I'm new to this, I could use help from anyone. is there a way to attached the current data from the user form submitted instead of the whole workbook with all the data submitted from different user and as a pdf file?

Thank you
Marilyn