Thread: Send email depending on cell values in selected row

Yes, that is possible.

Dummy code which you can modify as per your requirements :

Dim OutApp As Object
    Dim OutMail As Object
    Dim strbody As String

    Set OutApp = CreateObject("Outlook.Application")
    OutApp.Session.Logon
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    With OutMail
        .To = "me@here.com"
        .CC = ""
        .BCC = ""
        .Subject = "The Filefor #" & Chr(32) & Range("H4") & " has been updated."
        .Body = "Please review." & vbCrLf & vbCrLf & ActiveWorkbook.FullName
        .Send   'or use .Display
        .ReadReceiptRequested = True
    End With
    On Error GoTo 0


    Set OutMail = Nothing
    Set OutApp = Nothing
    
    Dim Msg, Style, Title
        Msg = "E-mail has been sent " & Chr(13) & Chr(10) & "Press OK to continue."
        Style = vbOKOnly + vbInformation
        Title = "Open Issues List"
        Response = MsgBox(Msg, Style, Title, Help, Ctxt)

I assume that you have enough knowledge of VBA to modify it as per your requirements. If not, please let me know, I will help you out.

The attachment is also possible. You can use FileSystemObject, or Application.FileSearch as well.

Let me know if you need more help.

Thanks,
Vikas