Adding userform inputs to email VBA Code to body of email
<p>I need to be able to send an email from Excel, but I want the body of the email to contain values from a userform after you press submit.</p>

<p>I have tried different things, but I am stuck with the below code.</p>

<pre><code>Dim aOutlook As Object
Dim aEmail As Object
Dim rngeAddresses As Range, rngeCell As Range, strRecipients As String

Set aOutlook = CreateObject("Outlook.Application")
Set aEmail = aOutlook.CreateItem(0)

'set Importance
aEmail.Importance = 2
'Set Subject
aEmail.Subject = "TestMailSend"
'Set Body for mail
aEmail.Body = "Campaign Name" &amp; Me.ComboBox5.Value
              "Job Number" &amp; Me.ComboBox4.Value
              "Revenue" &amp; Me.ComboBox3.Value


'send one off to 1 person use this static code
'aEmail.Recipients.Add "E-mail.address-here@ntlworld.com"
aEmail.Recipients.Add "Insert email address here"
'Send Mail
aEmail.Send
</code></pre>