(Solved) – Excel Macro to Send an Email Using a Template Removes All Images from the Template


I am using excel to send out emails based on an oft file using the following code.

Dim olApp As Outlook.Application
Dim myEmail As Outlook.Mailitem

Set olApp = CreateObject("Outlook.Application")
Set myEmail = olApp.CreateItemFromTemplate(".file.oft")

myEmail,To = "clientemail@email.com"

When I use the oft file directly in Outlook, everything sends out fine, including images in the template.

When using the excel macro, the email message sends fine, but the images are removed from the email.

Not sure what I am doing wrong to get it to send out just as is without removing the images.

Leave a Reply

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