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 = ""