Paste Range (Table) As Image In Email Body | Excel VBA Macro

[@ultimate_muu]

Thanks! Very helpful! I wanted to copy a table and paste the table in an email. I used the same code with minor changes. Code below for reference: del -->Set pic = ws.Pictures.Paste del -->pic.Cut change this line---> .PasteandFormat wdChartPicture to ---> .Paste

[@greggowaffles]

So glad you figured it out! Thank you so much!!!

[@MrSweety143]

I tried this but the table is not getting pasted on the mail body. Any addin has to be enabled?

[@fabriceramazani465]

Thank you Sir! I spent 3 hours trying to write a code in VBA to send an email with embedded image in the email body, but external parties to my organization could not view the image. Now I came across your simple method and it works. Man I like the internet, thank you !!!

[@greggowaffles]

So happy to hear that!! No problem!!

[@anticlimactic165]

Been searching the web for a working code and yours is the only one that worked.

[@greggowaffles]

Glad to hear that!!

[@5639didi]

Great Video! By the way how to adjust the pic size that we have been copy and cut in outlook?

[@FusionBliss711]

This code really saved me! In conjunction with your other send email video as well. Keep up the good work, hope to see more from you soon!

[@greggowaffles]

Thanks for that! It really means a lot!!

[@ikemenman4995]

First time I've seen a video of yours, it was quite helpful. Thank you, Greg.

[@greggowaffles]

You’re welcome! Thank you for the feedback.

[@arianelourenco153]

Thks, Saved my day!!!!! Great Job 👏

[@purenrg4life]

Loving your videos man! Cannot believe you don't have more subs! Keep it up.. you're a great teacher and it is so SO helpful to have you talk through what you are doing in each video! Thanks so much for your efforts in making them

[@greggowaffles]

Really appreciate that! Thank you so much!!

[@kimcelidonio9899]

Hey greg, congrats for your videos. Its possible to resize the Image of the Range (table) in the email body? Thanks

[@pessimistic5579]

simply resize the table being copied in excel itself.

[@saraielizabethesparzagarci3544]

Thanks so much for this video!! You made my day!! How do I add another table from a different sheet? 🤔

[@Dinosword2000]

Thank you VERY MUCH! 👍

[@greggowaffles]

No problem! Thank you for watching!!

[@epark9925]

Just subscribed love the way you walk us through your codes in simple terms. Can you do a video on how to copy and paste a filtered dynamic table with hidden columns as an image into the email html body? Your help will be much appreciated.

[@FalconFlyer75]

much appreciated, exactly what I was looking for, Thanks

[@greggowaffles]

Awesome! Thanks for watching!!

[@germanhamermiler1371]

Hey! Good work. I have a question. When I run the macro The picture is pasted at the begining of the email and I need it at the bottom. How can i do it?

[@nhatanhnguyenhuu2745]

thank you !! your code help me alot !!

[@greggowaffles]

No problem! So glad to hear that!!

[@puxhay]

Thanks you 😊. What about to show the default signature in outlook?

[@someidiotchild]

How would we go about copying multiple ranges as images within the same email body?

[@matheusgameiro61]

amazing, bro! thanks

[@qiyang1996]

Thank you for the tutorial! May i ask how to loop the function again to insert another table ?

[@greggowaffles]

no prob! thanks for watching!! im still looking into looping this code, but i have another video that essentially does the same thing. its just that the tables arent converted into images before being added to the email body: kzbin.info/www/bejne/b6KbmI18ZbqCqpo

[@nikkiebrown2639]

This video made my entire day! Can you show how you would resize the chart?

[@greggowaffles]

absolutely! apologies for the delay. hope this video helps: kzbin.info/www/bejne/g3bMYqBvnZ5_a5o

[@mediamisfits3805]

You man are epic!

[@greggowaffles]

Thank you!

[@HugoPinheiroBorba]

Thank you a lot, it will help a lot :D

[@greggowaffles]

I hope it does help! Thank you for watching!!

[@asgerlarsen2083]

Great video! Is it possible to copy and paste multiple tables as picture format? I have watched your other video that uses RangetoHTML to paste tables, but unfortunately this work poorly when pasting PivotTables, it struggles with the formatting. The method of pasting the ranged as a picture solves this problem, now I just need to be able to paste multiple ranges into the same email. Thanks for the help so far!

[@pessimistic5579]

This is great and works lovely, but i found that the code breaks when you replace .Display with .Send in the outmail with block. i want the email to send automatically without the outlook window popping up. is there a workaround?

[@fatihakben6369]

Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The

[@Pokemoncharlizard]

What if there are 2 table pictures that we need to attached from 2 different tabs? Thank you for your help in advance.

[@jeffmiller4405]

You are amazing!!!!

[@greggowaffles]

Thank you!!

[@ivanarciniegas7324]

thank you!🥰

[@greggowaffles]

You’re welcome!! Thank you for watching!!

[@jeromeradtke3015]

great video, thank you.:)

[@greggowaffles]

Thanks for watching!!

[@manuelcalderon8482]

Great Tutorial, Greg!!! thank you so much :) May I ask how would you increase the size of the pic on the email?

[@greggowaffles]

No prob! Thanks for watching! Hope this video helps: kzbin.info/www/bejne/l6Tdn4GjrLR0ipo

[@nathanwhite7268]

@@greggowaffles hey this video is great. How can I increase the size of this pic in the body of the email (where you copy and cut it from excel). I have looked at your other video where you do this but with a png that is saved in a file location, however I can't seem to get it to work with the excel sheet image.

[@denzelhd]

asking the same qn! The vid is resizing png, doesn’t seem to work for excel image

[@gurpreetkaur-gd8np]

Same question! issue in the size of image

[@jasmadsen]

Has anybody ever found a solution to realize the table image in the body of the email?

[@ramrosales447]

Thanks Greg. It works awesomely fine. Question though. Can we resize the attached range pic via "with pic"?

[@greggowaffles]

yes! apologies for the delay. hope this video helps: kzbin.info/www/bejne/g3bMYqBvnZ5_a5o

[@harilibo]

just awesome!

[@greggowaffles]

Thank you!!

[@tekygenie]

Hey Greg Thank you so much for sharing these VBA tutorials. Helped me a lot to create one of my own. One help from you Instead of pasting in email, how can I export this image to a path

[@greggowaffles]

glad to hear that! thanks for watching! if you google SaveRangeAsPicture you should find some good stuff. ill make a video on this in the near future

[@tekygenie]

@@greggowaffles thank you again!!

[@greggowaffles]

No problem!

[@graywolfweb1361]

This is fantastic. I was struggling with how to do exactly this. Found other code but that code was WAY too complicated. Only thing I need to figure out is how to get my default signature to populate. If you have a suggestion that would be great. Gray.

[@jaysekhon8014]

Open up Outlook. Go to File, Options, Mail, then click Editor Options under Compose Messages. Then Click Advanced, scroll down to the Insert/Paste pictures as: and select Square. See if that fixes your problem (:

[@everteero5305]

Great video! Can you also make a video that shows how to pull distance info between 2 locations written in the cell from Bing Maps API into excel?

[@christophwissing4877]

Very nice video . I used the code but my image is not in the new email automatically . I do the Strg v to get the image in the email. What is my mistake ?

[@michelledelrosario5610]

Hello sir. This absolutely works! Thank you! Although, when pasted in outlook, the image version of my selected range becomes small. Is there any way I could set the size of the image in outlook using vba? Thank you!

[@timothyclayton2573]

i noticed the same problem.

[@MrSweety143]

​@@timothyclayton2573any solution to this problem

[@kingLostSouls]

This is a great example however I when I adapted my code to use the picture appears after my signature. My code previously would generate a pdf and then create the HTMLbody to have some text and my signature. Any ideas?

[@csabalubloy7693]

Does anyone know why I receive run-time error 1004: Microsoft Excel cannot paste the data. at the following line: Set pic = ws.Pictures.Paste? If I press again on running the code it prepares the email, but at first it stucks always.

[@fazlifantom9233]

@greggowaffles how to Paste Range (Table) in email using different excel. I have multiple excel workbook, which have 1 table per customer. Is it possible to copy and paste from the workbook to the email body as range/table format?

[@aaronjohnson2215]

Is it possible to just display this pictures as popup so user can copy?😊

[@aksharkesari2299]

This is amazing, Greg! Just one query, the image is overriding my Signature. Is there a way to fix it? Thanks

[@jaysekhon8014]

Open up Outlook. Go to File, Options, Mail, then click Editor Options under Compose Messages. Then Click Advanced, scroll down to the Insert/Paste pictures as: and select Square. See if that fixes your problem (:

[@dennisprada945]

Hi Greg! What if I need to Paste Range AS Image in Mail Body but this range is not a Tablet but a mix of graphic?

[@kenshinyusuke]

Is there a solution for doing this twice in one email?

[@JoaoVaralta]

Man, thanks for the video. I’m having and issue and I don’t know how to solve. It pastes nothing on the email body when I run the code. But if I press Ctrl+V I can paste the range on email body. How can I solve this?

[@jefflunsford1331]

Same here….

[@JoaoVaralta]

@@jefflunsford1331 man I wish I could help you but I don’t remember how I solved it. Try copying and pasting your script on chat gpt explaining you error. Maybe it could help you.

[@ianlafferty2264]

Very very new to VBA, learning a lot from these videos.I keep getting a compile error: Method or data member not found? Seems to stop at Pic.Cut. Suggestions anyone?

[@kontara]

Thanks!

[@greggowaffles]

Thank you so much! I really appreciate it!!

[@kreamypie]

What if i have multiple work sheets and i only want to grab the raange of the work sheet that i am currently on and convert it to image?

[@tonyod.1161]

Hi, great tutorial! However, our version is probably different, I can't define something as Picture in VBA... I tried Image and Graphic instead, but it give me a type mistmatch error. Anyone have an idea what can I use instead?

[@denzelhd]

Same question here! Do let us know Greg!

[@drewandres6359]

what is the code to paste range as images for two tables in the same sheet? thanks

[@kayepatrick5809]

do you have ways how to add a link to the image pasted in the email body?

[@joshuatravatello1805]

I keep getting Run-time error '429': ActiveX component can't create object!!! Do you have any advice, I've been breaking my head trying to figure this out.

[@robertomonteiro4713]

Hi, I need to copy 2 differents grafics in 2 differents sheets, how can I do?

[@anferneechen6232]

I tried the exact same codes but it only creates an email with To: and Subject: Why is the body blank?

[@ThePlatinumaster]

Can I paste the image into a different range?

[@timothyclayton2573]

This works great Except the pasted image is very small. Too small to read. Is there an easy way to enlarge this?

[@greggowaffles]

yes! apologies for the delay. hope this video helps: kzbin.info/www/bejne/g3bMYqBvnZ5_a5o

[@hhouston7181]

Hi, how would you increase the size of the pic on the email?

[@nicingram1719]

Is there any way I can paste a range of cells that are non contiguous?

[@stephenjhayes83]

newbie here, how to run this on a button?

[@balasubramaniandharmalinga5723]

Hi Greg, How can we add multiple tables to outlook?

[@greggowaffles]

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

[@asgerlarsen2083]

@@greggowaffles Is it possible to add multiple tables, but pasted as pictures?

[@MrJcole0502]

This pastes the image when you display the picture without sending but when you change .display to .send, it sends it without the image. Has anyone figure this one out yet?

[@vivekkrishnagrawal889]

How to paste multiple range as picture ?

[@minhtrungtran3675]

Code debug at "set pic=ws.pictures.paste" with error Run time 1004. Can everyone help me?

[@seanharper1314]

Can you automatically press send then move to the next worksheet?

[@seanharper1314]

And do this until you get to the last worksheet

[@LG-pv8kr]

Great video,but it doesn't paste the Pic...😅

[@DiLombardi]

pic.cut gives an error, has anyone figured it out?

[@Alexkip2008]

Hi i've got an error 424 on line Set OutMail = OutApp.CreateItem(0)

[@Alexkip2008]

sorry my fault .. it works :)

[@changhi3743]

This code does not work. It either uses methods that don't exist anymore or variables not declared.

[@nicholaslorenzo8120]

when I tried to use this line of code at work, I had pic.cut launch a massive stack of code that took a few minutes to run. Does anyone else have this same problem?

[@MichaelVargas]

@greggowaffles Great video, easy to follow. Do you know how to add the information as table instead of image?. Also, how can I add data from specific cell into the subject line?. This is the code that I have: Sub Send() Dim OutApp As Object Dim OutMail As Object Dim table As Range Dim pic As Picture Dim ws As Worksheet Dim wordDoc Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) 'grab table, convert to image, and cut Set ws = ThisWorkbook.Sheets("Form") Set table = ws.Range("B4:C21") ws.Activate table.Copy Set pic = ws.Pictures.Paste pic.Cut 'create email message On Error Resume Next With OutMail .To = "" .CC = "" .BCC = "" .Subject = "Credit Review for" & "" & Range("C4") & "" & Range("C6") .Display Set wordDoc = OutMail.GetInspector.WordEditor With wordDoc.Range .PasteandFormat wdChartPicture .insertParagraphAfter .insertParagraphAfter .InsertAfter "Regards," .insertParagraphAfter End With .HTMLBody = "Hello Risk Management, Could you please run a credit review of this location? " & .HTMLBody End With On Error GoTo 0 Set OutApp = Nothing Set OutMail = Nothing End Sub

[@AlexWigal]

When I run the code, I get a Run-time error '9': "Subscript out of range" When I select debug, it highlights "Set ws = ThisWorkbook.Sheets("EOSReport")" Any insight? Thank you!!

[@greggowaffles]

Maybe there’s a space “ “ in the tab name