Excel VBA Macro: Send Email with Embedded Image/Picture in Body (Step-by-Step Tutorial)

[@Jojosmith342]

all thumbs up to Greg the greatest teacher. Thank you for teaching. Already subscribed from the 1st lesson. Hope the others would do so

[@petewarby7158]

I'm going to watch this again to grasp it, bl**dy brilliant though. The only other video I have seen glosses over everything you did at the start, your video is REALLY comprehensive (I think)... I'm going to give it a go later on. Thank you so much for creating this video, I think it's EXACTLY what I have been looking for!!!!!!! You're a star :)

[@garzco]

Thank you! This was something I wanted to do but didn't know how... with your example I solved what I needed to do in less than 20 minutes.

[@greggowaffles]

No prob! So glad to hear that!!

[@brianforbes3012]

Thanks mate. Appreciate your efforts on sharing the Code. Worked, the FIRST time :)

[@greggowaffles]

So glad to hear that!!

[@zeynepe.5587]

very useful, thank you :)

[@ankita6162]

Really very useful

[@HowToX]

Thank you. I was trying to add an image, and the message boards were not helping. I also needed to add breaks after the image, and I was able to adapt your statements to make that happen.

[@greggowaffles]

So glad to hear that!!

[@androjxe6298]

Thank you very much, you help me a lot

[@greggowaffles]

You’re welcome! Thank you for watching!!

[@suserman7775]

Interesting. Thumbs up. How would this work if the graphic is whatever is copied in the clipboard, as opposed to in a file ?

[@greggowaffles]

If you search GetFromClipboard you can see how to turn the graphic into a DataObject and go from there

[@athossantana2987]

Thanks, man!

[@greggowaffles]

Glad to help!

[@KenDilas01]

How could I grab images that are already in the Excel sheet, in specific cells. I won't know the image name, just it's location.??

[@douglasrodrigues4744]

The best one

[@corywilliams3699]

How do you print screen the current workbook to the email body and not a picture?

[@FilipoLipos]

Hey, if I want to move the image to the right? I was trying right='10' but that did not worked. thanks for help

[@haroldquek1655]

Hi Greg, loved your video! How do I add a picture as my email signature?

[@bhar2855]

You can use the snipping tool and then save it as a .PNG file. You can follow the similar file path that he has but unique to your PC and save it there.

[@RoyAliKhairan]

Cool! Can you also lemme know how to center an image in the mail boy? Thank in advance

[@greggowaffles]

just made a video on this. hope it helps! kzbin.info/www/bejne/l6Tdn4GjrLR0ipo

[@cristinaferreira6019]

if you take a close look at it the "font-family:Arial" is not working, the outlook still inserts the text in calibri

[@aaronb8699]

Can you have the body of text, then an image then text under the image again?

[@omkarjethe34]

How can I put Thanks and regards after the attached image.. pls share me coding if possible...

[@ankitjainkaka]

Please send sample file for bulk emailing for sending pdf files and their snapshot in email body from a folder.

[@greggowaffles]

i'll see what i can do

[@ankitjainkaka]

@@greggowaffles please 🙏 awaiting for your reply.

[@AllShitRandom]

Me too😏😏😏

[@ankitjainkaka]

@@greggowaffles still awaiting for your reply

[@arkjah1]

How do I do the same if I want a Microsoft Word fillable form to display in the body of an email (outlook) instead of, as an attachment?

[@greggowaffles]

I don't know of a direct way to do this off-hand. You would need to use an external website or database to have a fillable form. You can try designing a form in Outlook by enabling the Developer tab and see what you come up with. Sorry I can't be more helpful!

[@xavierampe2155]

Hi Greg, made a copy of you code but the image is blanc/transparency in the email? link to the image is good, everything double checked. Any idea?

[@xavierampe2155]

Hi Greg, After many tests, it worked!! The image was blanck because of the variable path and the quotes. Here under the solution if some other persons are facing the same issue ____________ dim path1 as string path1 = "'D:\user\Desktop\filename\test.png'" 'code of greg in the youtube video " " _ 'rest of the youtube code by the way, forgot to thank you for the tuto regards

[@greggowaffles]

Glad to hear that!! Thanks for sharing that 🤝

[@denzelgohh]

Hi Greg, what if the image is within a cell in my sheet? Please do get back to me! Your videos really help me out so much!

[@denzelgohh]

The image is pasted as a picture in a cell

[@crystalbowlby6588]

How to forward email with embedded image in body? I had .display, but get red x,x ,x only. I don't want to download the images from the incoming email.

[@farrahfranco6276]

how do you get this to be sent to multiple emails?

[@greggowaffles]

Hope this helps! kzbin.info/www/bejne/bXTLpqSwarJpa7c

[@rwlupus]

I'm struggling with such task. I've got outlook message saved as .msg. Email contains html formattting which I want to preserve but only replace images, also keep position and size. I'm trying to add new picture as hidden attachement but stuck how to replace old pictures. Any clue?

[@greggowaffles]

not exactly sure what youre trying to do, but i hope this helps: www.slipstick.com/developer/code-samples/delete-attachments-messages/ apologies for the late reply

[@paulcordova4812]

Thanks, someone knows how to send Email witch picture but using gmail? when I try it looks black :(

[@chenvandersluijs8669]

hi, any idea how to do this with gmail?

[@greggowaffles]

hi. hope this helps! www.automateexcel.com/vba/send-emails-gmail/

[@gabrielmontenegro1942]

I tried but when the other person checked the email the image is broken

[@TimWallder]

Same - empty frame

[@greggowaffles]

sorry to hear that. does everything look fine before you send it off?

[@piercethelight]

@@greggowaffles hey I'm having the same issue, everything looks fine when i send it but on the receiving end its broken

[@greggowaffles]

@@piercethelight hey! whats your code look like?

[@francobrucato3657]

Hi, I had the same issue. The problem seems to be that the image is not sent as an attachment. Instead it takes the picture from the path of your image. Since the receiver doesn't have that image at that path, he will not be able to see it. A simple way to verify this is to move or rename the image after sending the email. In this case the sender will not be able to see the picture as well

[@bhar2855]

Hi, thanks for this. I was struggling trying to get my signature to include the image but I took a screen capture of the whole signature and used this method instead. Mine has a table inserted which is whatever cells I have selected and then it has my signature right after. The only question I have and wonder if you might be able to advise is how I might have a gap between the table and the signature. that portion of the code I have is as follows: .HTMLBody = "Updated attendance through yesterday. Any newly printed incidents are en-route to respective warehouse manager." & _ RangetoHTML(rng) & _ "" _ & .HTMLBody .Display 'or use .Send End With It puts my signature right underneath the table, but it would be nice if there was maybe just a one space gap as if I had hit the enter button once. Thoughts?

[@ankita6162]

How we can write some text on this image