Thread: Excel Marco: Compose Mail from Excel

Private Sub CommandButton1_Click()

Dim iRow As String
Dim Cancel As Boolean
    

    Range("k5").Select
    iRow = ActiveCell.Row
 
    If Not Cancel Then
        ActiveWorkbook.SendMail Recipients:=Range(""), Subject:="iRow"
        
    End If
End Sub

Hello,

I have the above code. The code will compose a new email with a selective subject based on a cell.

Now, I came up with this coding using internet resources but could not get it to output a cell value (string) as the subject of the email. Is it possible? If then how should I approach it?

In a sense, I want the subject to be

"<Cell Value> Vendor Request"

Thanks in advance!

Edit:

I put in

        ActiveWorkbook.SendMail Recipients:=Range(""), Subject:=Range("iRow" & "Vendor Request"

but gave me error