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

greggowaffles

Рекомендации по теме

Комментарии

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

You're a star :)

petewarby

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

Jojosmith

Thank you very much, you help me a lot

androjxe

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

omkarjethe

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

cristinaferreira

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.??

KenDilas

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

suserman

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

corywilliams

How we can write some text on this image

ankita

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.

crystalbowlby

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

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

paulcordova

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

ankitjainkaka

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

RoyAliKhairan

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

haroldquek

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

gabrielmontenegro

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

farrahfranco

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 = "<BODY attendance through yesterday. Any newly printed incidents are en-route to respective warehouse manager.</BODY>" & _
RangetoHTML(rng) & _
"<img _
& .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?

bhar

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.

HowToX

hi, any idea how to do this with gmail?

chenvandersluijs

Excel VBA Macro: Send Email with Picture in Body (Embedded Image)

Send Mail From Excel via Outlook

Excel VBA Macro: Send Email (with Attachment)

Excel VBA - Send Excel Tables via Outlook Emails

Excel VBA Macro: Send Email (with Outlook)

Excel VBA Macro: Send Email with Picture in Body (Embedded Image)

VBA to Automate Sending Email From Excel Table with Attachment from Folder

Excel VBA Macro: Send Email With Table In Body (Dynamic Range)

Excel VBA Macro: Send Email from a Specific Account (in Outlook)

How to use Chatgpt with Excel | Send an email from Excel using VBA

Excel VBA Macro: Send Email with All Files (in a Specific Folder) Attached

Send Email with Attachment (Invoice) using Excel VBA Button

Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution)

Excel VBA Macro: Send Email (with Hyperlink)

Send Multiple Emails From Excel

How to send email using Gmail via Excel VBA

How To Send Email from Excel with Table in Outlook Body VBA Macro

Send Fully Dynamic Emails from Excel with a SINGLE FORMULA | No VBA Required!

How to Automatically Send Emails With HTML Tables Using Excel VBA Macros

Excel VBA Macro: Send Email with Attachments from a List (Dynamic Range)

How To Automatically Send Customized Emails With Attachments Using Excel Macros

Excel VBA Macro: Send Email With Multiple Tables In Body (Static and Dynamic Ranges)

Excel VBA Macro: Send Email with Dynamic Hyperlink (Variable Based on Cell Value)

How to create VBA code in Excel to send Emails through Outlook automatically | VBA

Send Bulk Emails From Your Gmail Account Using Excel VBA (with Attachments) | Excel TEMPLATE 😎