Пікірлер
@sagarsamantaloknath9279
@sagarsamantaloknath9279 2 күн бұрын
Thanks
@mizanranawat5940
@mizanranawat5940 2 күн бұрын
File not found in the path where I have saved... please help
@two-onebee7030
@two-onebee7030 7 күн бұрын
This has proven very useful for a project I'm working on. Could you possibly explain how to add more than one table as separate images into the email body?
@thomasrusli1934
@thomasrusli1934 7 күн бұрын
Hello, how about filter based on specific value in the cell, for the example the value is "Amer", so the data will be show as Northern America, Latin Amer & Carib, etc
@praiserofthesun3645
@praiserofthesun3645 7 күн бұрын
5 years later and you saved my ass just because I actually forgot how to do this bs, thanks a lot man
@greggowaffles
@greggowaffles 7 күн бұрын
Anytime! 😎
@kumaraprabaharan8669
@kumaraprabaharan8669 8 күн бұрын
Hi Brother, need ur help to get code for. Instead of selecting region one by one . can i give in range of cells with region i required. Need the each region in seperate sheet
@Drew-vp
@Drew-vp 8 күн бұрын
Hi what if you have a cell with defined name. How can you reference that ?
@user-vg5lm5zl6g
@user-vg5lm5zl6g 9 күн бұрын
How to autofilter and copy a table data to Outlook email by VBA Code
@minhtrungtran3675
@minhtrungtran3675 10 күн бұрын
Code debug at "set pic=ws.pictures.paste" with error Run time 1004. Can everyone help me?
@tramanand
@tramanand 13 күн бұрын
Can't thank you enough....exactly what i was looking for...deep appreciation🙏🙏🙏
@tramanand
@tramanand 13 күн бұрын
Terrificc...thanks a ton!!! 🙏🙏
@Pokemoncharlizard
@Pokemoncharlizard 14 күн бұрын
What if there are 2 table pictures that we need to attached from 2 different tabs? Thank you for your help in advance.
@andyw.8402
@andyw.8402 15 күн бұрын
I have a folder with emails saved. Each email contains a zip folder that contains csv files. Can you do a video on how to go through all the emails, unzip the files and consolidate the csv files into one csv file using vba/macro?
@ma.cedezcatherinemalijan2200
@ma.cedezcatherinemalijan2200 15 күн бұрын
Hello! I need this same function but not using pivot. I need to copy and paste a certain range from excel to outlook. Please help
@karinbeyaert9950
@karinbeyaert9950 16 күн бұрын
It works. Great, thanks! But in my Excel it also works without the join and split steps. Only difference seems you are using a 1 or a 0 based array. It eventually gives the same filtering.
@ultrahen2755
@ultrahen2755 7 күн бұрын
can you share the code?
@karinbeyaert9950
@karinbeyaert9950 7 күн бұрын
@@ultrahen2755 Sure I can. But it is the same as shown here in the video. I only noticed that you can skip 2 of these transformations.
@ultrahen2755
@ultrahen2755 7 күн бұрын
@@karinbeyaert9950 my list no show or zero, i dont know why, already type the code from the video
@adampatterson3125
@adampatterson3125 16 күн бұрын
I keep running into issues with the Set pic = ws.Pictures.Paste line, gives me Run-time error '1004': Unable to get the Paste property of the Pictures Class. Any ideas? Thanks!
@MohamedAboAbdo03
@MohamedAboAbdo03 17 күн бұрын
Thank you so much
@federicopelizza9563
@federicopelizza9563 18 күн бұрын
thank you, i've spent too much time commenting out lines to debug stuff.
@brittaniguidry6061
@brittaniguidry6061 22 күн бұрын
Ron's site is no longer available... can you paste the code somewhere so I can copy it?
@sakhilengwenya594
@sakhilengwenya594 24 күн бұрын
Is there a reason why didn’t you do a For loop, this looks complicated
@kpcrompton
@kpcrompton 27 күн бұрын
Thank you for the easy to follow tuition. Is it possible for the source data to start a cell other than "A1" and then the range start from there? Thanks again.
@sakhilengwenya594
@sakhilengwenya594 28 күн бұрын
Thank you 🙏
@ArvinMartinez-of7tj
@ArvinMartinez-of7tj Ай бұрын
How about if we put our list starting to B2, what would be code?
@ajaz4sky
@ajaz4sky Ай бұрын
Great explanation, really understood everything pretty easily.. better than other tutorials on progressbar in vba
@greggowaffles
@greggowaffles 29 күн бұрын
Appreciate the feedback!
@omkarjethe34
@omkarjethe34 Ай бұрын
How can I put Thanks and regards after the attached image.. pls share me coding if possible...
@sharadpatel07
@sharadpatel07 Ай бұрын
Hi Greg its help me a lot but i have to paste data in other sheet & create multiple forms from master sheet, how can i do it ?
@ankita6162
@ankita6162 Ай бұрын
Really very useful
@ankita6162
@ankita6162 Ай бұрын
How we can write some text on this image
@MuhammadFAH33M
@MuhammadFAH33M Ай бұрын
Hi Nice Video 👍 Question ❓ I want the code to Auto pick file name from a Cell Value Can you please tell me how to do it. Also please update the VBA code & share it with people feedback given in comments Thanks 🙏 I've Subscribed to your Channel ❤
@abcdefg20939
@abcdefg20939 Ай бұрын
Heii! :) Thanks for the great explanation - i was able to implement that! :) However, I do have an issue and i really really hope there is a quick and easy fix. I don't want an exact match of the criterias, I need a "contains" match. i tried to do Criteria1:=list & "*" but that didnt work. I tried an asterix at the beginning and end of my criteria in the original criteria list, but that also didn't work. I would be super grateful, if you could help me!
@petewarby7158
@petewarby7158 Ай бұрын
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 :)
@fatihakben6369
@fatihakben6369 Ай бұрын
Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The
@russf62
@russf62 Ай бұрын
Fantastic, so helpful, thanks. Had created code to clear a weekly timesheet at start of new week but wanted to add the option to save a copy before doing so. Just a few minor tweaks and voila... 😊
@greggowaffles
@greggowaffles Ай бұрын
🙌🙌🙌
@vidya7596
@vidya7596 2 ай бұрын
Thank you Greg for this video, this is what I was looking for. I tried to replicate the same but getting an error Error "Run-time error 1004, Application-defined or object-defined error" in the line Set pop = Sheets("Form").Range(Cells(1, 1), Cells(count_row, count_col)) is it possible to share this file please :)
@MrJcole0502
@MrJcole0502 2 ай бұрын
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?
@lanceross1035
@lanceross1035 2 ай бұрын
Helpful video. I didn't realize at first why Field was 2, but figure it out. You present well.
@greggowaffles
@greggowaffles 2 ай бұрын
Appreciate that!
@finvest_queen
@finvest_queen 2 ай бұрын
amazing! thanks, like 👍👍👍
@shafiqr2000
@shafiqr2000 2 ай бұрын
Great video. Many thanks
@greggowaffles
@greggowaffles 2 ай бұрын
Thank you!
@LG-pv8kr
@LG-pv8kr 2 ай бұрын
Great video,but it doesn't paste the Pic...😅
@sundarsinghpthula
@sundarsinghpthula 2 ай бұрын
How to attach only specific sheets in Excel
@Dexter101x
@Dexter101x 2 ай бұрын
Can't VBA use anything other than Outlook? I find it very limiting, since I already have an email manager
@jorgettesantos711
@jorgettesantos711 2 ай бұрын
Hi gregg, great video... is it possible to use the .SentOnBehalfOfMe function on Word mail merge?
@makubexho
@makubexho 2 ай бұрын
great solution and coding in tackling the self-inflicted predicament by that poster - the intention of including such large amount of databody from Excel into the email body is beyond me - Do you not find it more appropriate and secure to store the data in an Excel file and attach it in the email for distribution? If I was the recipient of that email with a large table of content in the email body I would be like "WTH.."
@makubexho
@makubexho 2 ай бұрын
use outlook and emails for its purposes that are originally designed best for - do not stretch its application to fit some "eye-catching" stunts some people are blindly searching for
@greggowaffles
@greggowaffles 2 ай бұрын
Thanks for the feedback!! Gotta give the people what they want 😎
@maxwellelias5244
@maxwellelias5244 2 ай бұрын
Thank you very much, bro! This was exactly what I needed for finishing a project from work before going to the airport to finally be on vacation! :D
@greggowaffles
@greggowaffles 2 ай бұрын
No prob! Happy to help!!
@greggowaffles
@greggowaffles 2 ай бұрын
hello! check out this video if your'e running into issues when using large ranges: kzbin.info/www/bejne/qIKzl6qeqteMZ9U
@rhondarhocksExcel
@rhondarhocksExcel 2 ай бұрын
Missed you GreggoWaffles. Fan of your videos. Could you do one similar to this but using Instr to find a partial string? I'm almost there and haven't been successful.
@shaikmohammed9971
@shaikmohammed9971 2 ай бұрын
Hey buddy, Thanks for the fantastic content. Just a quick question on font type/family. Though we selected Arial, draft is coming as Calibri. Can you please help?
@adarshVernekar-ez5tt
@adarshVernekar-ez5tt 2 ай бұрын
You are great! Code works perfectly fine👍 thank you so much
@greggowaffles
@greggowaffles 2 ай бұрын
Thank you!!
@suthamwintachai6559
@suthamwintachai6559 2 ай бұрын
thank you
@GGPG
@GGPG 2 ай бұрын
hi sir, i came acrros your video, very help, but how do i change the size of the image pasted on the email please?? hope you can answer my question