I have a macro, which reads some data from excel, formats it as per need and then send email to my team. Currently the body of an email has only texts. I need to add three color shapes to the body of email ( Yellow, Red and Green).
Is there any way to add color shapes in body of email ? Its totally fine, even if all colors are formatted in one image file and is attached to body of email. I saw many solutions online but they all use mmtl code to get image from server location, my team is spread out and not everyone has access to server so I want to use the image from same excel workbook. Here is the part of code I have for sending emails.
Note - The partial code which works for email is attached in word file(I am unable to paste html code here). I just need to add one more image to the body of email from existing sheet.
Bookmarks