No video
Excel VBA Macro: Send Email with Picture in Body (Embedded Image)
Excel VBA Macro: Send Email with Picture in Body (Embedded Image). In this video, we go over how to use img src to embed an image in an email body and send a message through Outlook. We also go over how to adjust the size of the picture used with altering the height and/or width.
#ExcelVBA #ExcelMacro
Пікірлер: 57
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 :)
all thumbs up to Greg the greatest teacher. Thank you for teaching. Already subscribed from the 1st lesson. Hope the others would do so
Really very useful
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
2 жыл бұрын
No prob! So glad to hear that!!
Thanks mate. Appreciate your efforts on sharing the Code. Worked, the FIRST time :)
@greggowaffles
2 жыл бұрын
So glad to hear that!!
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
3 жыл бұрын
So glad to hear that!!
very useful, thank you :)
Thank you very much, you help me a lot
@greggowaffles
2 жыл бұрын
You’re welcome! Thank you for watching!!
Thanks, man!
@greggowaffles
3 ай бұрын
Glad to help!
The best one
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.??
Interesting. Thumbs up. How would this work if the graphic is whatever is copied in the clipboard, as opposed to in a file ?
@greggowaffles
3 жыл бұрын
If you search GetFromClipboard you can see how to turn the graphic into a DataObject and go from there
How can I put Thanks and regards after the attached image.. pls share me coding if possible...
How we can write some text on this image
Hey, if I want to move the image to the right? I was trying right='10' but that did not worked. thanks for help
if you take a close look at it the "font-family:Arial" is not working, the outlook still inserts the text in calibri
How do you print screen the current workbook to the email body and not a picture?
Hi Greg, loved your video! How do I add a picture as my email signature?
@bhar2855
2 жыл бұрын
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.
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
3 жыл бұрын
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!
Can you have the body of text, then an image then text under the image again?
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.
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!
@denzelhd
2 жыл бұрын
The image is pasted as a picture in a cell
Cool! Can you also lemme know how to center an image in the mail boy? Thank in advance
@greggowaffles
2 жыл бұрын
just made a video on this. hope it helps! kzread.info/dash/bejne/k6eu0LCmp7KnhJs.html
Thanks, someone knows how to send Email witch picture but using gmail? when I try it looks black :(
Please send sample file for bulk emailing for sending pdf files and their snapshot in email body from a folder.
@greggowaffles
3 жыл бұрын
i'll see what i can do
@ankitjainkaka
3 жыл бұрын
@@greggowaffles please 🙏 awaiting for your reply.
@AllShitRandom
3 жыл бұрын
Me too😏😏😏
@ankitjainkaka
3 жыл бұрын
@@greggowaffles still awaiting for your reply
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
3 жыл бұрын
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
3 жыл бұрын
Glad to hear that!! Thanks for sharing that 🤝
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
3 жыл бұрын
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
how do you get this to be sent to multiple emails?
@greggowaffles
Жыл бұрын
Hope this helps! kzread.info/dash/bejne/aXec19OzZbCcZbg.html
I tried but when the other person checked the email the image is broken
@TimWallder
3 жыл бұрын
Same - empty frame
@greggowaffles
3 жыл бұрын
sorry to hear that. does everything look fine before you send it off?
@piercethelight7166
3 жыл бұрын
@@greggowaffles hey I'm having the same issue, everything looks fine when i send it but on the receiving end its broken
@greggowaffles
3 жыл бұрын
@@piercethelight7166 hey! whats your code look like?
@francobrucato3657
3 жыл бұрын
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
hi, any idea how to do this with gmail?
@greggowaffles
3 жыл бұрын
hi. hope this helps! www.automateexcel.com/vba/send-emails-gmail/
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?