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
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 !!!
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?
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?
Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The
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.
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.
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!
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 ?
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: th-cam.com/video/9q8gZF0UOt8/w-d-xo.html
@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?
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
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?
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.
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?
@@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.
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 (:
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.
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 (:
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!
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
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 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.
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?
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?
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!!
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?
@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
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
So glad you figured it out! Thank you so much!!!
I tried this but the table is not getting pasted on the mail body. Any addin has to be enabled?
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 !!!
So happy to hear that!! No problem!!
Been searching the web for a working code and yours is the only one that worked.
Glad to hear that!!
Great Video! By the way how to adjust the pic size that we have been copy and cut in outlook?
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?
How would we go about copying multiple ranges as images within the same email body?
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!
Thanks for that! It really means a lot!!
Thanks you 😊. What about to show the default signature in outlook?
Thanks so much for this video!! You made my day!!
How do I add another table from a different sheet? 🤔
What if there are 2 table pictures that we need to attached from 2 different tabs? Thank you for your help in advance.
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?
Hey greg, congrats for your videos.
Its possible to resize the Image of the Range (table) in the email body?
Thanks
simply resize the table being copied in excel itself.
Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The
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.
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.
Thks, Saved my day!!!!!
Great Job 👏
Is there a solution for doing this twice in one email?
Is it possible to just display this pictures as popup so user can copy?😊
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!
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 ?
Thank you for the tutorial! May i ask how to loop the function again to insert another table ?
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: th-cam.com/video/9q8gZF0UOt8/w-d-xo.html
@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?
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
Really appreciate that! Thank you so much!!
Thank you VERY MUCH! 👍
No problem! Thank you for watching!!
First time I've seen a video of yours, it was quite helpful. Thank you, Greg.
You’re welcome! Thank you for the feedback.
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?
thank you !! your code help me alot !!
No problem! So glad to hear that!!
Can I paste the image into a different range?
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.
Hi, I need to copy 2 differents grafics in 2 differents sheets, how can I do?
This video made my entire day! Can you show how you would resize the chart?
absolutely! apologies for the delay. hope this video helps: th-cam.com/video/MEi1m9h9L58/w-d-xo.html
do you have ways how to add a link to the image pasted in the email body?
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?
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?
what is the code to paste range as images for two tables in the same sheet? thanks
I tried the exact same codes but it only creates an email with To: and Subject: Why is the body blank?
much appreciated, exactly what I was looking for, Thanks
Awesome! Thanks for watching!!
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?
newbie here, how to run this on a button?
Thanks Greg. It works awesomely fine. Question though. Can we resize the attached range pic via "with pic"?
yes! apologies for the delay. hope this video helps: th-cam.com/video/MEi1m9h9L58/w-d-xo.html
Is there any way I can paste a range of cells that are non contiguous?
Great Tutorial, Greg!!! thank you so much :)
May I ask how would you increase the size of the pic on the email?
No prob! Thanks for watching! Hope this video helps: th-cam.com/video/asznNmwOAT8/w-d-xo.html
@@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.
asking the same qn! The vid is resizing png, doesn’t seem to work for excel image
Same question! issue in the size of image
Has anybody ever found a solution to realize the table image in the body of the email?
This is amazing, Greg! Just one query, the image is overriding my Signature. Is there a way to fix it? Thanks
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 (:
Hi, how would you increase the size of the pic on the email?
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.
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 (:
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!
i noticed the same problem.
@@timothyclayton2573any solution to this problem
amazing, bro!
thanks
Thank you a lot, it will help a lot :D
I hope it does help! Thank you for watching!!
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
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
@@greggowaffles thank you again!!
No problem!
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?
How to paste multiple range as picture ?
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?
Same here….
@@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.
Code debug at "set pic=ws.pictures.paste" with error Run time 1004. Can everyone help me?
This works great Except the pasted image is very small. Too small to read. Is there an easy way to enlarge this?
yes! apologies for the delay. hope this video helps: th-cam.com/video/MEi1m9h9L58/w-d-xo.html
You man are epic!
Thank you!
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?
Same question here! Do let us know Greg!
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?
thank you!🥰
You’re welcome!! Thank you for watching!!
great video, thank you.:)
Thanks for watching!!
Hi Greg, How can we add multiple tables to outlook?
Hope this helps! th-cam.com/video/9q8gZF0UOt8/w-d-xo.html
@@greggowaffles Is it possible to add multiple tables, but pasted as pictures?
Great video,but it doesn't paste the Pic...😅
You are amazing!!!!
Thank you!!
pic.cut gives an error, has anyone figured it out?
Can you automatically press send then move to the next worksheet?
And do this until you get to the last worksheet
This code does not work. It either uses methods that don't exist anymore or variables not declared.
just awesome!
Thank you!!
Hi i've got an error 424 on line Set OutMail = OutApp.CreateItem(0)
sorry my fault .. it works :)
Thanks!
Thank you so much! I really appreciate it!!
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!!
Maybe there’s a space “ “ in the tab name
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?
@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