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 !!!
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
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.
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?
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: ruclips.net/video/9q8gZF0UOt8/видео.html
Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The
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?
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?
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!
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!
@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?
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?
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
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 ?
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?
@@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.
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 (:
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?
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.
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 (:
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.
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
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!!
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!!!
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!!
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!!
Great Video! By the way how to adjust the pic size that we have been copy and cut in outlook?
Thks, Saved my day!!!!!
Great Job 👏
You man are epic!
Thank you!
How would we go about copying multiple ranges as images within the same email body?
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!!
First time I've seen a video of yours, it was quite helpful. Thank you, Greg.
You’re welcome! Thank you for the feedback.
Thanks you 😊. What about to show the default signature in outlook?
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.
much appreciated, exactly what I was looking for, Thanks
Awesome! Thanks for watching!!
This video made my entire day! Can you show how you would resize the chart?
absolutely! apologies for the delay. hope this video helps: ruclips.net/video/MEi1m9h9L58/видео.html
Thank you VERY MUCH! 👍
No problem! Thank you for watching!!
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.
Thanks so much for this video!! You made my day!!
How do I add another table from a different sheet? 🤔
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?
thank you !! your code help me alot !!
No problem! So glad to hear that!!
What if there are 2 table pictures that we need to attached from 2 different tabs? Thank you for your help in advance.
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.
amazing, bro!
thanks
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: ruclips.net/video/9q8gZF0UOt8/видео.html
Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The
You are amazing!!!!
Thank you!!
Is it possible to just display this pictures as popup so user can copy?😊
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?
Thank you a lot, it will help a lot :D
I hope it does help! Thank you for watching!!
Is there a solution for doing this twice in one email?
thank you!🥰
You’re welcome!! Thank you for watching!!
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?
great video, thank you.:)
Thanks for watching!!
just awesome!
Thank you!!
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?
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.
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!
@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?
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?
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?
Thanks!
Thank you so much! I really appreciate it!!
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!
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 ?
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!
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: ruclips.net/video/asznNmwOAT8/видео.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 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 (:
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?
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: ruclips.net/video/MEi1m9h9L58/видео.html
Great video,but it doesn't paste the Pic...😅
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?
Hi, I need to copy 2 differents grafics in 2 differents sheets, how can I do?
do you have ways how to add a link to the image pasted in the email body?
How to paste multiple range as picture ?
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?
Code debug at "set pic=ws.pictures.paste" with error Run time 1004. Can everyone help me?
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.
Can I paste the image into a different range?
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 (:
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: ruclips.net/video/MEi1m9h9L58/видео.html
Is there any way I can paste a range of cells that are non contiguous?
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.
Hi, how would you increase the size of the pic on the email?
newbie here, how to run this on a button?
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
Hi Greg, How can we add multiple tables to outlook?
Hope this helps! ruclips.net/video/9q8gZF0UOt8/видео.html
@@greggowaffles Is it possible to add multiple tables, but pasted as pictures?
Hi i've got an error 424 on line Set OutMail = OutApp.CreateItem(0)
sorry my fault .. it works :)
This code does not work. It either uses methods that don't exist anymore or variables not declared.
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
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