How to insert an image into a HTML E-Mail body?

[SOFL]

hi all,

Does anyone has a solution on how to insert an image into an HTML E-Mail body with a Macro when the files name was previously defined?
The Filename was defined as follow and stored in a local folder.
Filename = Range("C49").Value

The idea is to create Factsheets and each has a different name. Therefore the HTML Code has to be flexible.

I'm using this code for this step:

With OLmail
.to = " "
.cc = " "
.BCC = " "
.Subject = " "
.attachments.Add "N:\" & Filename & ".emf", 0
'here you can ajust the picture size in the mailbody (width and heigt)
.htmlbody = .htmlbody & "<img src='cid:Filename.emf'" & "width='1000' heigt='4000'><br>"
.Display
End With


Thanks for your response

Flo

[Norie]

Flo

You would need to have the actual value of Filename in the HTML.

Try this.

Please Login or Register  to view this content.

PS When posting code can you please use CODE tags?

[SOFL]

Hi Norie,

Thanks for the quick response. Sadly it does not work properly... When the E-Mail is created it states that "the linked image cannot be display" and the image is in the attachment and not in the body.
However, when I take an actual file with the name "1" for example the attachmet is properly hidden and the image visible in the body. Is there an other way around to leave the file connection flexible?

Sorry will use code tags in the future.

Best,
Flo

[Norie]

Flo

When you try it with an actual filename is that file an emf file?

[SOFL]

Yes it is the same file that I just renamed for this test purpose.

I tied it aswell as .gif/.png/.jpg but it didn't work...

[Norie]

What is the value of Filename when things don't work?

[SOFL]

I don't see a value. How can I look this up? and Filename is defined as string. Could this might cause the problem?

[Norie]

The value of the variable Filename is set here.

Please Login or Register  to view this content.

Does C49 have a valid path and filename to the image you are trying to show in the email?

[SOFL]

C49 should be the name of the image. However, it was probably to compilcated with multiple & and _ in it. I've found a solution that works.
Thanks a lot for your help and have a good evening.

Greetings,
Flo