(Solved) – How can I embed an image from worksheet using VBA?


I am trying to embed a logo to the body of an Outlook email using VBA.

Currently my picture is stored in a shared drive called “Z”, and is being pasted to a new Outlook Message using the code below:

Dim EmailMessage As Object
Set EmailMessage = EmailClient.CreateItem(0)

With EmailMessage
    .To = ""
    .CC = ""
    .BCC = ""
    .Subject = "KEY123 Approval Needed for TM Products and Services"
    .Bodyformat = 2

    .HTMLBody = ""
End With

How can I reference the path to point to a worksheet? I would like to use the image stored in Sheet 1 the image name is “shield”

What I would like: .HTML Body = ""

Leave a Reply

Your email address will not be published. Required fields are marked *