VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet.VBA-Excel: Create worksheets with Names in Specific Format/Pattern.VBA-Excel: Read XML by Looping through Nodes.Send Mail with Embedded Image in message body-1 Send Mail with Embedded Image in message body-2Įnter your email address to subscribe to this blog and receive notifications of new posts by email. MsgBox ("you Mail has been sent to " & SendID) ‘it will be changed to the correct cid when its sent. ‘change the src property to ‘cid:your image filename’ ‘Now add it to the Html body using image name Attachments.Add "C:\Users\Sumit Jain\Pictures\11\city.jpg", olByValue, 0 ‘add the image in hidden manner, position at 0 will make it hidden
Subject = mainWB.Sheets("Mail").Range("B3").Valueīody = mainWB.Sheets("Mail").Range("B4").Value SendID = mainWB.Sheets("Mail").Range("B1").ValueĬCID = mainWB.Sheets("Mail").Range("B2").Value Set olMail = otlApp.CreateItem(olMailItem) Set otlApp = CreateObject("Outlook.Application") Ides is to attach the image in hidden manner and later add it to using image name in the HtmlBody.
#Outlook email template image size how to#
In this tutorial you will learn how to add an image in the mail body or message and send it from Microsoft Outlook. ( I recommend you first read these articles to understand the basics if you are new to this) In previous articles you have learned about Send a Simple Mail From MS Outlook Using Excel and how to send Attachment With the Mail MS Outlook Using Excel.