Hi All -
I have spreadsheet that lists different tasks the user may want a support team to complete. Ideally, the user can click a button next to activity name which would open up a userform displaying certain options, fields for information,etc.
There would then be a button at the bottom of the userform that would be tied to VBA - opening up Outlook, automatically populating the To field and subject line, as well as inserting the userform, or at least the information that it contains.
I have been able to figure out how to open Outlook, populate the TO and subject lines, but cannot figure out how to transfer the userform into the body of the email.
Any thought?
I have spreadsheet that lists different tasks the user may want a support team to complete. Ideally, the user can click a button next to activity name which would open up a userform displaying certain options, fields for information,etc.
There would then be a button at the bottom of the userform that would be tied to VBA - opening up Outlook, automatically populating the To field and subject line, as well as inserting the userform, or at least the information that it contains.
I have been able to figure out how to open Outlook, populate the TO and subject lines, but cannot figure out how to transfer the userform into the body of the email.
Any thought?
Code:
Private Sub CommandButton1_Click()
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = "ESS_CSST@ntrs.com"
.CC = ""
.BCC = ""
.Subject = "Open Account of GAM-PAO"
'[B]body of email goes here[/B]
'Body =
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub