Send e-mails via VBA with embedded picture

[andreeasimon]

Hi,

I have been using VBA to send e-mails to multiple contacts for a while now. I am now struggling to add also an embedded picture (logo) to my e-mails.

I tried multiple variations for the script:

I tried with .png, .img and so on. I am able to attach the picture to the e-mail, but in the body of the e-mail I am not able to see the picture (logo in this case), it is always displayed like this:

Any help would be very much appreciated!

Thanks you

 

[Domenic]

First, attach your image to your email . . .

 .Attachments.Add "c:\users\domenic\desktop\sample.png"

And then embed it like this . . .

        .HTMLBody = "<br><img src='cid:sample.png'>" & _

Hope this helps!

 

[andreeasimon]

First, attach your image to your email . . .

 .Attachments.Add "c:\users\domenic\desktop\sample.png"

And then embed it like this . . .

        .HTMLBody = "<br><img src='cid:sample.png'>" & _

Hope this helps!

Thanks so very much!

I used: .AddAttachment "C:\Users\andreea-simon\Downloads\sample.PNG"

and after:
"<br>" & "<img src='cid:sample.png' >" & _

and now I have the image finally embedded!

Any change you know how to make the attachment invisible? As I do not want it to appear as an attachment, only embedded in the body of the e-mail.

Thanks again!

 

[Domenic]

To hide the attachment, set the Position argument to 0. . .

        .Attachments.Add Source:="C:\Users\andreea-simon\Downloads\sample.PNG", Type:=1, Position:=0

Or, without named arguments . . .

        .Attachments.Add "C:\Users\andreea-simon\Downloads\sample.PNG", 1, 0

See the following documentation for a reference . . .

Attachments.Add method (Outlook)

Office VBA reference topic

docs.microsoft.com

 

[andreeasimon]

Hi,

Thanks!

The only issue is that I cannot use .Attachments.Add as I always get the bellow error:

I need to use .AddAttachment Range("H1").Value, 1, 0 (I mentioned the path for the image in cell H1 of my sheet) for it to work.
However, the attachment is still visible.

Any advice is very much appreciated!

 

[Domenic]

What object is being referenced? Can you post a fully qualified reference?