[VBA] [Generate Email] - End of Subject line

Hello,

I have a VBA Macro set to generate an Outlook email based on data in my userform. I already have conditions and IF statements written out to generate the subject line contents. However, I am hoping to find a way to have the macro check if ComboBox1 = "Y", then add "Hello" to the end of the Subject line already existing contents. Any help would be great

What code are you already using to input the subject line?

I am using the below code:
Its really confusing, but basically I already have an IF statement that has to run in the macro. Once this IF statement is complete it adds the data I need to the Subject line. After that I need to add three different checks/conditions based on other ComboBoxes. Those three checks will add additional text to the end of the contexts I already have in the subject line. I hope that makes sense.

With OutMail

.To = TextBox19.Text & ";" & TextBox18.Text & ";" & TextBox15.Text & ";" & TextBox16.Text
.CC = TextBox24.Text & ";" & TextBox25.Text
.BCC = ""

'IF CONDITION STATEMENT...................

If TextBox41 = "" Then

.Subject = TextBox10.Text & "/" & TextBox1.Text

GoTo CT
Else
End If

.Subject = TextBox10.Text & "/" & TextBox1.Text & " & " & TextBox41

CT:
.HTMLBody = RangetoHTML(Rng)
.Display

End With

try this after your last End if:

Please Login or Register  to view this content.

This replaces:
.Subject = TextBox10.Text & "/" & TextBox1.Text & " & " & TextBox41

Not sure if that is going to work cause I have three checks to make, listing below. All three come after the primary IF statement I have above.

If ComboBox1 = "Y" & ComboBox2 = "Y" Then "Hello World"
Else

If ComboBox1 = "Y" Then "Hello"
Else

If ComboBox2 = "Y" Then "World"

So the whole thing will be:

Please Login or Register  to view this content.

Awesome, this is what I needed. Testing now!
Question though, I shouldn't need the CT: since its not part of the IF statement, correct?

Correct. That can go away.

Thank you so much, worked perfectly! :D