How do I reference a cell that contains a FilePath for a photo i would like to embed onto email?

44 views Asked by At

Hello there i'm trying to reference a cell that contains a File path for a JPG image I would like to include in my email as an embedment. How can this be done, thank you.

Sub SendSubTo_email()

    Set we = Sheets("Master_Tab")
    Dim PhotoFilePath As String
    PhotoFilePath = we.Range("J5")

    EmailItem.HTMLBody = img src=PhotoFilePath width='90%' height='90%'

Screenshot: enter image description here

0

There are 0 answers